Sheet Tabs options greyed out
 

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

Sheet Tabs options greyed out
 

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"DeanH" wrote:
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

Sheet Tabs options greyed out
 

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" wrote:

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"DeanH" wrote:
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

Sheet Tabs options greyed out
 

I'm out here. Hang around for insights from others.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"DeanH" wrote in message
...
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

Sheet Tabs options greyed out
 

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 wrote:

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

--

Dave Peterson

Sheet Tabs options greyed out
 

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" wrote:

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 wrote:

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

--

Dave Peterson

Sheet Tabs options greyed out
 

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!



DeanH wrote:

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" wrote:

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 wrote:

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

--

Dave Peterson


--

Dave Peterson