Forum Discussion
Unprotecting a workbook
When protecting a workbook's structure you MUST enter a password. If there is no password, the structure is not protected.
See the support article for details on how protecting the structure works.
Thank you for the quick reply, Ingeborg, however both my experience and the link you provided contradict your statement: please see attached image 'Protect.PNG', cut from the support article you provide, which shows that the password is optional. Menawhile, in this workbook, navigating to File -> Protect Workbook confirms that the structure of the workbook is protected,
However, this is not really the issue, as I am never challenged for a password. Nor am I trying to add protection, only remove it. But, as soon as I uncheck the (checked) 'Structure' box the 'OK' button greys out and is unclickable.
I have no idea why this protection is there; it wasn't the last time I opened the workbook. It's in a Dropbox folder which has this evening been synced to a new W7 machine. Since the last time I opened it in W7 I have opened it on a Linux laptop in LibreOffice, but not saved any changes, so I doubt this is the problem.
Thank you again for your reply.
Cheers MD.
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.
