View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Otto Moehrbach Otto Moehrbach is offline
external usenet poster
 
Posts: 1,090
Default Turning off/on protection 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?