Auto-Protect Sheet on Open and on Close
Yes, I am aware of the shortcomings.
Thanks, both of you.
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.
"Luke M" wrote:
As Eduardo mentions, you can setup a password. However, please note that it
is VERY easy to disable macros, or to simply use another macro (available
online) to crack a sheet protection password in 1 to 2 minutes. So, at best,
a sheet protection password provides a hindrance.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"ryguy7272" wrote:
I have the following code in ThisWorkbook:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Call ApplySecurity
End Sub
Private Sub Workbook_Open()
Call ApplySecurity
End Sub
I have this in a Module:
Sub ApplySecurity()
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
ActiveSheet.EnableSelection = xlNoSelection
End Sub
I just noticed that whether macros are enabled or disabled, a user can just
click Tools Protection Unprotect and make any changes they want; Excel
doesnt even ask me for a password. Did I miss something here?
Ryan--
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.
|