Unable to completely unprotect workbook

sierk

New Member
Joined
Aug 27, 2018
Messages
1
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,
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Forum statistics

Threads
1,213,536
Messages
6,114,211
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top