Unprotected workbook won't let me rename tabs

[raysha22]

Hi everyone!

I have a workbook that I have placed a password protection on. When I unprotect the workbook, I can edit all of the contents but it will not let me rename the tab or add a new sheet. How can I fix this?

 

[Fluff]

Are you sure that you have unprotected the Workbook, rather than a worksheet

 

[raysha22]

Are you sure that you have unprotected the Workbook, rather than a worksheet

I never protected the workbook as a whole and I unprotected each worksheet. Is there something I'm missing?

 

[Fluff]

It sound like you have workbook protection set.
On the Review try clicking Protect Workbook

 

[raysha22]

It sound like you have workbook protection set.
On the Review try clicking Protect Workbook

That worked. Everytime I looked at that one I thought it would say UNprotect workbook if I had it protected! Thanks for the help!

 

[Fluff]

Glad to help & thanks for the feedback.

Unfortunately it doesn't say UnProtect the same way that sheet protection does, but if the workbook is protected then the icon should be highlighted.