The Sheet-Rename feature is greyed-out in my Excel 2003 workbook..

  • Thread starter Thread starter Marlene
  • Start date Start date
M

Marlene

One of my Users has a workbook created under Excel 2003. We are now using
Excel 2007. The User wants to Rename her Sheet Tabs but the Rename feature
is greyed-out as though the Workbook is password-protected. When clicking on
Home-Cells-Format there appears to be no password and my User knows of none.
I've also tried SaveAs and checked "Tools-General Options": nothing is marked
but the 'Password to Open' window was greyed-out and the file's title-bar
said "(shared)" so I re-saved it as another name and removed the sharing
option at save-time, closed & reopened, but still the Rename feature on the
Sheet tab is greyed-out. Any suggestions will be appreciated.
 
You are looking in the wrong place for protection.

Review tab>protect workbook. Uncheck "protect structure and windows"


Gord Dibben MS Excel MVP
 
Back
Top