Hi all,
First of all many thanks for all the good stuff on this forum!
I'm using this forum for a while but can't find the answer to my problem this time, thanks for your help!
In my macro to protect I use:
ThisWorkbook.Protect Password:="BlaBla!", structure:=True, Windows:=True
To unprotect
ThisWorkbook.Unprotect Password:="BlaBla!"
But the result in not as expected.
In the File Info it states: "The structure of the workbook has been locked to prevent...."
But in the details everything seems to be unprotected.
The normal text after unprotecting would be "Control what types of changes people can make to this workbook.."
In the workbook I cannot use most but not all the functionality anymore.
For example in the View tap (with normal view selected) some features like 'freeze pane' and 'Split' are grayed out.
Maybe this has nothing to to with the proctection as normally you would be able to use them in a procected mode but I cannot find out how to be able to use these features again.
If you need more info please let me know,
First of all many thanks for all the good stuff on this forum!
I'm using this forum for a while but can't find the answer to my problem this time, thanks for your help!
In my macro to protect I use:
ThisWorkbook.Protect Password:="BlaBla!", structure:=True, Windows:=True
To unprotect
ThisWorkbook.Unprotect Password:="BlaBla!"
But the result in not as expected.
In the File Info it states: "The structure of the workbook has been locked to prevent...."
But in the details everything seems to be unprotected.
The normal text after unprotecting would be "Control what types of changes people can make to this workbook.."
In the workbook I cannot use most but not all the functionality anymore.
For example in the View tap (with normal view selected) some features like 'freeze pane' and 'Split' are grayed out.
Maybe this has nothing to to with the proctection as normally you would be able to use them in a procected mode but I cannot find out how to be able to use these features again.
If you need more info please let me know,