Save a macro button onto a toolbar

[BG Mark]

I have cerated a macro button in a spreadsheet, and I would like to know if
it is possible to save that button onto a toollbar so that I can use it on
any spreadsheet.

 

[trip_to_tokyo]

EXCEL 2007

Try this:-

1. Office Button (top left hand corner).

2. Excel Options (lower right hand corner).

3. Customize.

On the right hand side in here there is a section called:-

Choose commands from:

Click on the drop down arrow and select Macros.

4. A list of available Macros should appear on the left hand side.

Click the one that you want then click on the Add>> button.

5. Your Macro should now appear on the right hand side.

6. You can move its position on the Quick Access Toolbar by clicking the up
or down arrows (on the far right hand side).

7. Finally click OK.

8. Your Macro should now be assigned to the Quick Access Toolbar.

If my comments have helped please hit Yes.

Thanks.

 

[Gord Dibben]

Excel 2003

Tools>Customize>Commands>Macros

Drag smiley face up to a Toolbar.

Right-click and assign macro.

Note: you can also change the Icon image and its name..


Gord Dibben MS Excel MVP

 

[BG Mark]

Unfortunately I am using excel 2003, and cannot see the 'Office' button

 

[Dave Peterson]

Saved from a previous post:

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

In xl2007, those toolbars and menu modifications will show up under the addins.

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an
addin)
or
http://www.rondebruin.nl/2007addin.htm

And Bob Phillips shows a way to use a wrapper so that it can work in both xl2003
and xl2007.
http://msmvps.com/blogs/xldynamic/archive/2010/03/27/deploy-me-simple.aspx

 

[BG Mark]

Belatedl but many thanks

EXCEL 2007

Try this:-

1. Office Button (top left hand corner).

2. Excel Options (lower right hand corner).

3. Customize.

On the right hand side in here there is a section called:-

Choose commands from:

Click on the drop down arrow and select Macros.

4. A list of available Macros should appear on the left hand side.

Click the one that you want then click on the Add>> button.

5. Your Macro should now appear on the right hand side.

6. You can move its position on the Quick Access Toolbar by clicking the up
or down arrows (on the far right hand side).

7. Finally click OK.

8. Your Macro should now be assigned to the Quick Access Toolbar.

If my comments have helped please hit Yes.

Thanks.

 

[BG Mark]

A long overdue thank you

Saved from a previous post:

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

In xl2007, those toolbars and menu modifications will show up under the addins.

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an
addin)
or
http://www.rondebruin.nl/2007addin.htm

And Bob Phillips shows a way to use a wrapper so that it can work in both xl2003
and xl2007.
http://msmvps.com/blogs/xldynamic/archive/2010/03/27/deploy-me-simple.aspx

 

[BG Mark]

A late reply but many thanks

Excel 2003

Tools>Customize>Commands>Macros

Drag smiley face up to a Toolbar.

Right-click and assign macro.

Note: you can also change the Icon image and its name..


Gord Dibben MS Excel MVP



.