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 tabprotect workbook. Uncheck "protect structure and windows"


Gord Dibben MS Excel MVP



On Fri, 29 Jan 2010 12:32:01 -0800, Marlene
wrote:

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.