Command Bars

K

KneeDown2Up

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
 
J

JE McGimpsey

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

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)
 
Top