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

macros

ResolvedVersion 2003

Philip has attended:
Excel Intermediate course
Excel Advanced course

Macros

How can i create a macro shortcut in the toolbar section?

RE: Macros

Hello Philip

Thank you for your question.

You can create a toolbar button to run a macro by doing the following:

1. Go to Tools - Customise.
2. Go to Commands.
3. From Categories on the left, select Macros.
4. Select the Custom Button on the right, use your mouse to drag & drop the Custom Button onto a toolbar at the top of the screen.
5. Once the button is on the toolbar, right-click and select Assign Macro.
6. Select the macro you wish to attach to the button, and click OK.

I hope this helps.
Amanda

Fri 28 Nov 2008: Automatically marked as resolved.

Excel tip:

Add Text to Displayed Numbers in Excel 2010

To add text to a number in a cell, you need to go to the Home tab on the Ribbon, and click on the Cells group. Select Format Cells from the drop down menu then Custom from the Category list. In the Type box select General. After the word General, enter a space, then opening quotation marks, then the word you want to type and then closing quotation marks. Click on OK and you have your text!

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.26 secs.