Unprotected workbook won't let me rename tabs

raysha22

New Member
Joined
Nov 28, 2017
Messages
14
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?
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,529
Office Version
365
Platform
Windows
Are you sure that you have unprotected the Workbook, rather than a worksheet
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,529
Office Version
365
Platform
Windows
It sound like you have workbook protection set.
On the Review try clicking Protect Workbook
 

raysha22

New Member
Joined
Nov 28, 2017
Messages
14
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,529
Office Version
365
Platform
Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,098,867
Messages
5,465,159
Members
406,415
Latest member
silungwewilliam

This Week's Hot Topics

Top