note re macros_word2007

note re macros_word2007 - COST AND MANAGEMENT ACCOUNTING 1...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
COST AND MANAGEMENT ACCOUNTING 1 Creating Macros and Macro Buttons - Office 2007 A macro is a procedure that stores a list of statements that perform specific procedures. Recording a Procedure with a Macro Recorder Choose Developer->Record Macro Enter the name you wish to assign to the macro in the Macro Name box; enter a brief description in the description box; click OK; you are now in the recording phase; all the steps you enter will be included in the macro; when the procedure steps are complete, Choose Developer Stop Recording Running a Macro Before running a macro, always save a backup of the file in case the macro destroys vital information on your folder. Go to a new sheet before running the macro (or to a sheet that does not contain data in the cells that the macro will fill when it is run.) To run a macro, choose Developer->Macro->select the appropriate macro name from the choices in the dialog box->click the Run button Attaching a Button to a Macro To attach a button to a macro procedure, choose Developer-->Insert- ->select the button choice (square with smaller square inside----first button in upper left corner of available choices). Using the right mouse button, drag the cursor to the desired location, size by expanding the pointer
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

note re macros_word2007 - COST AND MANAGEMENT ACCOUNTING 1...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online