Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Restoring Toolbars and Other Things
I have a program that uses a custom toolbar exclusively, I hide all other
toolbars. If the user exits the program using the custom menu or toolbar, the standard toolbars that were displayed previously are restored. If the user exits my program using ALT-F4, selects the close 'x' button in the upper right corner, or clicks on the upper left corner and selects close, the toolbars are not restored as needed/expected. How can I capture (preferably) or disable these avenues of exit. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Restoring Toolbars and Other Things
A good way is to put the retore toolbar code in the the ThisWorkbook, under
the procedure workbook_beforeclose. This will restore the toolbars before excel closes down, whichever way excel closes. Jason Ashton "PosseJohn" wrote: I have a program that uses a custom toolbar exclusively, I hide all other toolbars. If the user exits the program using the custom menu or toolbar, the standard toolbars that were displayed previously are restored. If the user exits my program using ALT-F4, selects the close 'x' button in the upper right corner, or clicks on the upper left corner and selects close, the toolbars are not restored as needed/expected. How can I capture (preferably) or disable these avenues of exit. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Restoring | Excel Discussion (Misc queries) | |||
Restoring Worksheet | Excel Discussion (Misc queries) | |||
Restoring toolbar | New Users to Excel | |||
Activating & Restoring | Excel Programming | |||
Restoring Toolbars | Excel Programming |