Apply code to Icon

[Gator]

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?

 

[Gord Dibben]

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 Tools>Add-ins and it will remain active for all open workbooks.

I either case, assign the macro to a button through

Tools>Customize>Commands>Macros. 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

 

[Gator]

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

 

[Gord Dibben]

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