Adding icon to standard menu

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

Hi there,

I created a macro that compute and prints my report in
excel 2000, If I have my own icon, How could I add it to
the standard menu so that everytime I run my macro just
click it and go.

Thanks in advance for your tips.

Eric
 
Hi Eric

-Right click on your toolbar
-customise
-toolbars
-new
-give it a name, a new toolbar will appear in the
spreadsheet.

-Move it to you other toolbars
-Right click on the new toolbar
-customise
-Commands: select Macros
-Take "Custom Menu Item" and drag it to your new Toolbar
-right click on the new "Custom Menu Item" in the toolbar
-rename it and assign your macro

Good luck

Wolf
 
Back
Top