Sheet Tabs options greyed out

[DeanH]

Excel 2000 SP3

I have noticed that all the options for the Sheet Tabs (mouse-right click)
are greyed out.
Is there a check box somewhere to turn them back on?

Many thanks in advance.
DeanH

 

[Max]

Perhaps there's workbook protection applied ..

Try click Tools > Protection > Unprotect Workbook
(you may need a password)

Think there's also some features unavailable if the workbook is shared.
Check up Excel's Help for info.

 

[DeanH]

Thanks for replying.

Sorry, forgot to mention that the Workbook, Worksheet have NO protection on
them. Even if I restart Excel and create a new workbook, the options to
change the Sheet 1 Tab are greyed out.

Thanks
DeanH

 

[Max]

I'm out here. Hang around for insights from others.

 

[Dave Peterson]

Maybe it's time to reset that toolbar.

Hit alt-f11 to get to the VBE (where macros live)
hit ctrl-g to see the immediate window

Then type this and hit enter:
application.commandbars("ply").reset
Then back to excel to test it.

 

[DeanH]

Fantastic, Dave, You are the man!

This fix worked a treat.
Any idea why the toolbar fell over in the first place?
Or is it just a Microsoft thing! ;-)

Anyway, many thanks.
DeanH

 

[Dave Peterson]

I'd blame a developer!

Sometimes people want to take control of everything that excel can do. And
either they forget to put things back when they're done or something screws up
(excel/windows crashes) and the clean up code doesn't get run.

If you're the developer who may have done this, welcome to the club!