This macro locks the sheet when user clicks the button I added. But the following macro allows the user to unlock the sheet without a password by simply clicking "unprotect" in Excel 2007. How can I make it so that it prompts user for a password such that it won't unlock without the password.
_____________________________________
Sub SubmitFinal()
'
' SubmitFinal Macro
' Locks the Audit Template Allowing no more changes without password
'
'
With ActiveWindow
.Top = 7.75
.Left = 973
End With
Range("I26").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub
___________________________________
Kind thanks,
Eddie
_____________________________________
Sub SubmitFinal()
'
' SubmitFinal Macro
' Locks the Audit Template Allowing no more changes without password
'
'
With ActiveWindow
.Top = 7.75
.Left = 973
End With
Range("I26").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub
___________________________________
Kind thanks,
Eddie
