note re macros and macro buttons 04

note re macros and macro buttons 04 - COST AND MANAGEMENT...

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 A macro is a procedure that stores a list of statements that perform specific procedures. Recording a Procedure with a Macro Recorder Choose Tools-> Macro->Record New 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, click the Stop Recording button (the small box with the black dot). 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 Tools->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 View->Toolbars->Form ->select the button choice (square with smaller square inside). Using the right mouse button, drag the cursor to the desired location, size by expanding the pointer down and to the right, and release. A dialog box
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.

This note was uploaded on 03/03/2012 for the course ACCT 2460 taught by Professor Farrar during the Winter '12 term at Conestoga.

Page1 / 2

note re macros and macro buttons 04 - COST AND MANAGEMENT...

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