View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
wolf wolf is offline
external usenet poster
 
Posts: 24
Default Adding icon to standard menu

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

WLamik<atgmx.net

-----Original Message-----
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

.