Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a spreadsheet where I create a custom menu added to the Tools menu
when the workbook is opened. In the ThisWorkBook object, in the Sub Workbook_Open(), I have code that looks something like: Application.CommandBars("Worksheet men bar").Controls("Tools").Controls.Add(Type:=msoCont rolPopup).Caption = "Baselines" The menu is deleted when the workbook is closed by the Sub Workbook_BeforeClose(Cancel As Boolean) routine. This all works great. But if I open another workbook that has different data but the same macros, I get another copy of the Baselines menu. How can I check to see if the menu already exists and skip the creation/deletion step appropriately? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Test if file exists | Excel Discussion (Misc queries) | |||
How to test if a DLL (library) exists | Excel Programming | |||
Test for Worksheet Exists | Excel Programming | |||
Test if folder exists, create if it doesn't? | Excel Programming | |||
Test if a folder exists | Excel Programming |