View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tetreaultl tetreaultl is offline
external usenet poster
 
Posts: 1
Default Macro to protect and unprotect

I want to protect and unprotect a excel sheet with a macro, how do I pass
the password to the command?

Sub Macro12()
'
' Macro12 Macro
' Macro enregistrée l
'

'
ActiveSheet.Protect DrawingObjects:=True, Contents:=True,
Scenarios:=True
End Sub