View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
DeanH DeanH is offline
external usenet poster
 
Posts: 13
Default 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