Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
custom menu disappears when I File, Exit, Cancel
I have a couple of custom add-ins with functionality run from custom menu
options on the main menu (next to File, Edit, View, etc). Found a strange bug: when I have a dirty file, click on File, Exit and then Cancel, the custom menus disappear. The add-ins are still ticked in Tools, Add-ins so it's just the menu that's gone. Any ideas how to stop this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
custom menu disappears when I File, Exit, Cancel
I have used the AddinInstall and AddinUnistall events to create and destroy
the toolbars. That avoids the problem you describe. -- HTH... Jim Thomlinson "Smallweed" wrote: I've realised it's my auto_close macro (which deletes the menu each time). This runs even if you then cancel exiting. Is there a better event I could use? "Smallweed" wrote: I have a couple of custom add-ins with functionality run from custom menu options on the main menu (next to File, Edit, View, etc). Found a strange bug: when I have a dirty file, click on File, Exit and then Cancel, the custom menus disappear. The add-ins are still ticked in Tools, Add-ins so it's just the menu that's gone. Any ideas how to stop this? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
custom menu disappears when I File, Exit, Cancel
very good idea - thanks
"Jim Thomlinson" wrote: I have used the AddinInstall and AddinUnistall events to create and destroy the toolbars. That avoids the problem you describe. -- HTH... Jim Thomlinson "Smallweed" wrote: I've realised it's my auto_close macro (which deletes the menu each time). This runs even if you then cancel exiting. Is there a better event I could use? "Smallweed" wrote: I have a couple of custom add-ins with functionality run from custom menu options on the main menu (next to File, Edit, View, etc). Found a strange bug: when I have a dirty file, click on File, Exit and then Cancel, the custom menus disappear. The add-ins are still ticked in Tools, Add-ins so it's just the menu that's gone. Any ideas how to stop this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom menu disappears when I File, Exit, Cancel | Excel Programming | |||
Custom menu disappears | Excel Programming | |||
Can only exit the program from the file menu | Excel Discussion (Misc queries) | |||
How to restore a Custom menu if a user presses Cancel after selcting exit | Excel Programming | |||
Cancel Macro is user selects 'cancel' at save menu | Excel Programming |