How can I take some code I have on one worksheet that does formatting and
apply it to an icon that will display in the toolbar every time I open Excel
and every workbook?
--
Gator

Place the code into your Personal.xls which will load hidden each time Excel is
started. Macros will be available for all open workbooks.

OR into a new workbook which you then save as an Add-in.

Load through ToolsAdd-ins and it will remain active for all open workbooks.

I either case, assign the macro to a button through

ToolsCustomizeCommandsMacros. Drag the Smiley Face to your Toolbar and

right-click and "Asign Macro".

Note: you can edit the name and image of the button.


Gord Dibben MS Excel MVP

On Fri, 4 Jan 2008 12:20:01 -0800, Gator
wrote:

How can I take some code I have on one worksheet that does formatting and
apply it to an icon that will display in the toolbar every time I open Excel
and every workbook?

How to I assign the sub-procedure to a macro?
--
Gator


"Gord Dibben" wrote:

Place the code into your Personal.xls which will load hidden each time Excel is
started. Macros will be available for all open workbooks.

OR into a new workbook which you then save as an Add-in.

Load through ToolsAdd-ins and it will remain active for all open workbooks.

I either case, assign the macro to a button through

ToolsCustomizeCommandsMacros. Drag the Smiley Face to your Toolbar and

right-click and "Asign Macro".

Note: you can edit the name and image of the button.


Gord Dibben MS Excel MVP

On Fri, 4 Jan 2008 12:20:01 -0800, Gator
wrote:

How can I take some code I have on one worksheet that does formatting and
apply it to an icon that will display in the toolbar every time I open Excel
and every workbook?

You mean assign the macro to a button?

Right-click on the button and "Assign Macro"

If the macro is stored in an add-in you must type in the name of the macro.

If in Personal.xls just select from the dialog and OK


Gord

On Fri, 4 Jan 2008 13:31:06 -0800, Gator
wrote:

How to I assign the sub-procedure to a macro?