Excel 2007 : Unable to rename sheets

[crizzle]

for some reason, when i try to right click on a sheet and rename it, the option is grayed out. i dont have this problem on my other workbooks that are the same format.. im using excel 2007 and the workbook is saved as a Microsoft Office Excel Macro-Enabled Worksheet.

I have about 20 sheets in this workbook, that I would like to rename but cant... I checked and its not protected.

[Simon Lloyd]

It's not the worksheet that is protected but the workbook! if you look at workbook protection you will probably see that Structure and Windows have been checked, uncheck them and all will be well!