Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Customizing VB Macro on Menu Bar
I'm trying to add macro buttons to the menu bar when the
correct excel file is loaded. In another words, when the Excel file with the corresponding VB procedures (the macro buttons will be calling) is loaded, the customized macro buttons will be added to the menu bar. The buttons will disappear or unload when the excel file quits. I have been able to create such a macro button on the menu bar, however, the buttons stay resident (permanently) on my user account. It appears as a personal preference. I want this to be a global preference. For example, when I have another user open the file, the macro buttons do not appear on the menu bar until they manually add the macro button. I want any user whom open the excel file to have the custom macro buttons created on the menu bar. I know the macro buttons can be added to the menu bar automatically when the excel file loads. I hope I am clear about what I am trying to do and what the problem is. Anyone have any suggestions? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MACRO MENU | Excel Discussion (Misc queries) | |||
Customizing the menu in excel 2007 | Excel Discussion (Misc queries) | |||
Customizing Excel Worksheet Menu Bar without VBA coding | Excel Discussion (Misc queries) | |||
Customizing Worksheet Menu Bar for a workbook without VBA coding | Excel Discussion (Misc queries) | |||
Customizing Worksheet Menu Bar question. Help! | Excel Discussion (Misc queries) |