ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Adding icon to standard menu (https://www.excelbanter.com/excel-programming/285574-adding-icon-standard-menu.html)

Eric[_6_]

Adding icon to standard menu
 
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


wolf

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

.



All times are GMT +1. The time now is 03:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com