excel 2003 visual basic intermediate course - excel macros

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel 2003 visual basic intermediate course - Excel, macros

excel 2003 visual basic intermediate course - Excel, macros

resolvedResolved · Low Priority · Version Standard

Nikki has attended:
Excel Introduction course

Excel, macros

How do I add a macro to my toolbar?

RE: Excel, macros

Hi Nikki

Thank you for your question.

First you would need to add a button to a toolbar, then assign the macro to the button you have created.

To add a button to a toolbar:
1. Go to Tools - Customise - Commands then select Macros from the Categories list on the left.

2. From the Commands list on the right, select the Custom button. Drag and drop this onto an existing toolbar to the position where you want the button to be.

What displays on the button can be customised by right-clicking on the button, while you have the Customise dialogue box open. Close the Customise dialogue box when finished.

3. To attach a macro to the button, right-click on the button you have created and choose Assign Macro.

4. Select the macro you wish to attach to the button and click OK.

I hope this helps.
Amanda


 

Excel tip:

Find cells that match a format

In Excel you may wish to find cells that contain a specific formatting such s colour.

Select Edit > Find, click on Options and then Format...choose the formatting that you want found and click on OK

Choose one of the Find buttons to find.

View all Excel hints and tips


Server loaded in 0.09 secs.