Forum Discussion
Unprotecting a workbook
I have a workbook that suddenly has its structure protected. There is no password, but when I uncheck the 'Structure' box in the 'Protect workbook for' section of the 'Protect Structure and Windows' ...
IngeborgHawighorst wrote:When protecting a workbook's structure you MUST enter a password. If there is no password, the structure is not protected.
The dialog clearly states "Password (optional)".
Yes, password is optional, my bad.
When a file structure is protected (even without a password), then the icon in the ribbon is highlighted.
To remove the protection, click the icon in the ribbon. If there is no password, the icon simply changes colour and the workbook structure is no longer protected.
Thank you for this Ingeborg; please see my reply to Detlef's message.
Cheers MD.