Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding and Removing Custom Menu Items for one file...
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding and Removing Custom Menu Items for one file...
Jon,
In your Workbook_Open macro first delete than build... On Error Resume Next Application.CommandBars("mybar").Delete On Error GoTo 0 -- sb "Jon Kane" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding and Removing Custom Menu Items for one file...
Hi,
If MyMenu.Visible=True then exit sub Your menu won't be added twice. -- JP http://www.solutionsvba.com "Jon Kane" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |