Saturday, May 11, 2013

How to Reassign a Macro Button in Excel 2003


1. Open Excel 2003 and locate the macro button on your toolbar. Click 'Tools' on the menu bar and click 'Customize.' The Customize dialog box will appear. Click the 'Commands' tab. Click the macro on the toolbar and click the 'Modify Selection' button in the Customize dialog box.
2. Select 'Assign Macro.' The Assign Macro dialog box appears. Select a macro from the list and click 'OK.' If necessary, you can update the macro image by clicking the 'Modify' button in the Customize dialog box and select 'Change Button Image.'
3. Update the macro description by clicking the 'Modify' button and selecting 'Name.' Type a new name over the previous macro description. Click 'Close.' View the newly assigned macro on your toolbar.

Blogger news