Thread: Turning off/on protection in a macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default Turning off/on protection 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?

Reply With QuoteReply With Quote