reseting toolbars incase of fatal error

K

kimt

Afternoon All:

I am working on a program for internal distribution. When this progra
opens (through excel) the vbasic code disables all tool bars includin
the Menu bar. Every step of the way, the user has an option t
continue or abort. If the process is continued, when finished th
toolbars will be enabled. If it is aborted, the code enables the too
bars and closes (w/out saving) workbook. I know...as sure as the su
rises in the east, that someone is going to power off, or ctrl al
delete to get out of this operation. Is there a way, that excel ca
reset to default (re: enable toolbars).

Thank
 
N

Nikos Yannacopoulos

Kim,

Paste your toolbal restoring code to the Workbook_Open code section of
Personal.xls.

HTH,
Nikos
 

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

Top