Workbook Switching Strategy
"Nigel" wrote in message
...
I still have a potential problem(?) with the CommandBars collection - I
actually disable all standard xl menus, command bars and popups.
Re-enabliing these on the way out - is this status stored in the XLB? If
it
is then a power loss or other system crash will result in a user interface
corruption.
You could save the details to a text file, and the next time the workbook is
opened, check if the text file exists, if so, open, read, and restore the
commandbars.
|