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?