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

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

Gord Dibben

You are looking in the wrong place for protection.

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


Gord Dibben MS Excel MVP
 

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

Similar Threads

delete a sheet is greyed out 1
Unprotect a Shared Workbook - Option is Greyed Out 1
Greyed-out Share Workbook button 3
Sheet Tabs 5
Share Workbook command is not available (greyed out) 3
Sheet Tabs & Right Clicking 1
Sheet Tabs options greyed out 6
I want to print comments and the section is greyed out 2

Top