workbook Protection Toggle Macro
 

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!

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!

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!

glad to help

--
Don Guillett
SalesAid Software

"Just Learning" wrote in message
...
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!