CODEWITHSUNDEEP
excelvbaspreadsheet-protection
KingKong
KingKong

Reputation: 421

Workbook.Protect bug with toggling protection

When I call Thisworkbook.Protect in VBA the protection of the workbook actually toggles from the current workbook's protection status instead of just protecting the workbook.

Thisworkbook.Unprotect doesn't do this though.

Anyone know why this is the case or how to get around it?

Upvotes: 6

Views: 522

Answers (1)

vacip
vacip

Reputation: 5416

Not sure if it is by design or a bug... If you provide the parameters, it works fine:

ActiveWorkbook.Protect ,true,true

or

ActiveWorkbook.Protect Structure:= true

Whichever you need/want. This way it won't turn the protection off, only on.

To turn the protection off, you can use this (assumning you only turned on structure protection):

ActiveWorkbook.Protect Structure:= false

Parameters are:

.Protect(Password, Structure, Windows)

Upvotes: 4

Related Questions