course excel in london - 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 » course excel in london - Macros

course excel in london - Macros

resolvedResolved · Low Priority · Version Standard

Nisha has attended:
Excel Advanced course

Macros

how do I assign a macro on my toolbar.

RE: Macros

Hi Nicha

Thank you for your question about how to create a macro on your Excel toolbar.

To do this you must first create the macro you want to assign to the toolbar. Once you have done this, then you can assign it using the following method.


1.
Right click any toolbar at the top of the screen, and choose CUSTOMISE.

2.
Then choose the middle tab - COMMANDS

3. Scroll down to the bottom of the list on the left hand side, and choose MACROS

4. You will notice a smiley face appear on the right panel. Drag this icon to the location of your choice.

5.
To assign a macro, right click on icon that you have dragged to you r toolbar. In the menu that appears you will see ASSIGN MACRO

6.
Select the macro that you want to assign.

You can also change the icon by choosing EDIT BUTTON on CHANGE BUTTON IMAGE from the same menu you found ASSIGN MACRO on .

Does that answer your question?

If you have any further questions on Microsoft Excel, or any other Microsoft Office application, please feel free to post your questions for us to answer.

Regards

Richard
Microsoft Office Specialist


 

Excel tip:

3D formulas find and replace

After you know all the components of a 3D reference, you can change them to suit by using a localised Find and replace crt+f, if need be.

View all Excel hints and tips


Server loaded in 0.12 secs.