Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Scott
One way On the first line of the macro that create the menu delete your menu firs if it exist On Error Resume Next Application.CommandBars("MyCustomMenu").Delete On Error GoTo 0 Then create your menu -- Regards Ron de Bruin http://www.rondebruin.nl "scott" wrote in message ... I've got my vba code creating a custom menu called "mymenu". The code only loads the menu when certain spreadsheets open containing my criteria. What I can't figure out is how to detect if "mymenu" has already been loaded and if it has, don't load it a 2nd time. This happens sometimes because the user opens up several spreads that contain my special criteria in certain cells. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
custom menu | Excel Discussion (Misc queries) | |||
Custom Menu Help | Excel Worksheet Functions | |||
VBA - Disappearing custom menu and custom toolbar | Excel Programming | |||
Custom Menu return to Excel Menu upon Closing | Excel Programming | |||
Custom Menu | Excel Programming |