Command Bars

[Guest]

I have a spreadsheet which I have a code on its opening that disables various
command bars (standard etc). It enables them before close. It has worked fine
for some time, but now I find any other spreadsheet that I open, has these
bars disabled, despite changing the spreadsheet that I originally put this
line in.

Why is this and how do I get my other spreadsheets to show the bars without
having to put an enabling line of code in each time I want to use them?

Many thanks

 

[JE McGimpsey]

In your custom workbook, put code reenabling and redisabling the command
bars in Workbook_Deactivate and Workbook_Activate event macros,
respectively.

 

[Bob Phillips]

Use the Workbook activate and deactivate events to disable and enable just
as open and close does.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)