Jak
Well-known Member
- Joined
- Apr 5, 2002
- Messages
- 833
In Excel I go to customized, new menu and drag the new menu to the toolbar. Once the new menu is in place I go to macro and drag and drop several buttons to make the menu a drop down menu for the macros. Once this is done I assign each button a name and then assign the relevant macro to the button.
This is straight forward enough, but is a little long winded when it has to be done to a large number of PC’s. I have saved my personal.xls and have a .bat file that loads it onto each PC to allow access to the macros and update them as required. What would be better is a method of loading a drop down menu to the Excel toolbar with macro’s assigned. Please note I do not wish to load a saved workbook with the macro menu built in to the On_Open function. The method should be built into Excel or a .bat method if possible. Any ideas on how to tackle this problem would be welcomed.
This message was edited by Jak on 2002-05-15 06:27
This is straight forward enough, but is a little long winded when it has to be done to a large number of PC’s. I have saved my personal.xls and have a .bat file that loads it onto each PC to allow access to the macros and update them as required. What would be better is a method of loading a drop down menu to the Excel toolbar with macro’s assigned. Please note I do not wish to load a saved workbook with the macro menu built in to the On_Open function. The method should be built into Excel or a .bat method if possible. Any ideas on how to tackle this problem would be welcomed.
This message was edited by Jak on 2002-05-15 06:27