View Single Post
  #2   Report Post  
Just Learning
 
Posts: n/a
Default

Thanks! It works great!

"Don Guillett" wrote:

try

Sub protectunprotecttoggle()
If ActiveWorkbook.ProtectStructure = True Then
ActiveWorkbook.Unprotect Password = "d"
Else
ActiveWorkbook.Protect structu=True, Windows:=False, Password:="d"
End If
End Sub

--
Don Guillett
SalesAid Software

"Just Learning" wrote in message
...
Does anyone have a macro for toggling workbook protection?

E.g., run the macro and it unprotects the workbook if it's in a protected
state and vice versa.

Thanks for any help given!