Macros

Hi Andrew,

Welcome to the forum and thank you for your post; in answer;

Once you have created your macro you have a number of ways that it can be run;

1. Tools>Macro>Macros choose the macro and click Run
2. From a button created on the Toolbar' Right Click on the toolbars and from the menu choose Customize, click the Commands Tab and scroll until you see Macros, from the Commands Pane drag the Custom Macro button and deposit it on the toolbar, you can now assign a macro to this button, change its presentation (face image etc) at this point.
3. From a button created on your worksheet, Open the View>Toolbars>Forms toolbar and click on the Command Button then drag to create a rectangle on the worksheet, immediatly you will be presented with the Assign Macro dialog box, you can now assign your chosen macro to the button, make any editing changes at this point. Note: if you wish to edit the button in the future you must right-click on it and then choose from the menu.

I hope that has helped, regards Pete