Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I created a vba program in excel that creates a menu item on the main menu
bar when the file is opened and remove it when the file is closed. I use the Workbook_Open and Workbook_BeforeClose functions. However, if I open the file twice it gives me 2 of the menu items, and when I exit only the file and not the application, the menu items remain. Is there a way to get it to only add them menu item when the file is opened and then remove it when that file is closed???? Thanks for the help. --Jon |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Removing Pivit Table Items | Charts and Charting in Excel | |||
removing single items from list | Excel Worksheet Functions | |||
File & Help only active menu items | Excel Discussion (Misc queries) | |||
Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) | |||
Deleting custom Commands from File Menu are nor saved next time w. | Excel Worksheet Functions |