View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bill Manville Bill Manville is offline
external usenet poster
 
Posts: 473
Default removing and replacing toolbars

Paul James wrote:
if the power goes out or there is a system
crash while the application is running, so the Auto_Close event doesn't have
a chance to restore the toolbars (which include the menu bar), how does the
user restore the objects the next time Excel runs?


Been there - just double-click on your workbook and then close Excel using
wither a button in your application or the x button on the title bar. Your
Auto_Close will put the commandbars back.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup