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

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

In article ,
KneeDown2Up wrote:

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?

Ok Panic over - I sorted it. For reference I went into the immediates window
of 'book1' and put the lines of enabling code - pressed enter (checked the
sheet and the menus were there), saved the sheet! (took a few times to
realise despite no prompt if I tried to close sheet without saving, menus
wouldn't come back until I did so). ...phew!

"KneeDown2Up" wrote:

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

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)

"KneeDown2Up" wrote in message
...
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

Thanks guys - sorted.

"Bob Phillips" wrote:

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)

"KneeDown2Up" wrote in message
...
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