Turning off/on protection in a macro

[Guest]

How do you turn off and on the protection of a workbook in a macro?

 

[Chip Pearson]

Worksheets("Sheet1").Unprotect
or
Worksheets("Sheet1").Unprotect password:="whatever"

If you include the UserInterfaceOnly flag when you Protect the sheet, your
VBA code can do whatever it wants on a protected sheet. E.g.,

Worksheets("Sheet1").Protect UserInterfaceOnly:=True


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

 

[Otto Moehrbach]

Activeworkbook.Protect

Activeworkbook.Unprotect

HTH Otto