sitelbanat
Board Regular
- Joined
- Oct 17, 2005
- Messages
- 152
I recorded a macro to protect 2 sheets with a password, but when I click on the macro to protect the sheet, then go to tools unprotect sheet, it does not promt me for a password. Why is that? This is the macro am useing
Sub Protect_sheet()
'
' Protect_sheet Macro
'
'
'
Sheets("LABOR INPUT").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("BUDGET SHEET").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub
Sub Protect_sheet()
'
' Protect_sheet Macro
'
'
'
Sheets("LABOR INPUT").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("BUDGET SHEET").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub