Restoring Toolbars and Other Things

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Restoring Attached Toolbar 4
Cell Toolbar Dilemma xl2013 13
2003 toolbars problem 1
Custom Toolbar Below Other TBs 3
restoring toolbars 1
Unable to make my custom toolbar 'float' in Excel 2007 6
Deploying custom toolbar and custom icons 6
Window Event 2

Back
Top