Hello,

I added a password to the worksheet protection and then recieved a runtime
error related to this macro. Password is 1234, how can I insert the use of a
password into this macro?

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 10/28/2004 by bmd
'

'
ActiveSheet.Unprotect
Range("D9:D82").Select
Selection.ClearContents
Selection.Locked = False
Selection.FormulaHidden = False
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub

Thank You,
Brian