Sheet Tabs options greyed out

D

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
 
M

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.
 
D

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
 
D

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.
 
D

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
 
D

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!
 

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