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

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)

"Lucas" wrote in message
...
How do you turn off and on the protection of a workbook in a macro?

Activeworkbook.Protect

Activeworkbook.Unprotect

HTH Otto

"Lucas" wrote in message
...
How do you turn off and on the protection of a workbook in a macro?