Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto-Protect Sheet on Open and on Close
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''. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto-Protect Sheet on Open and on Close
Hi,
if you want your sheet to be protected use Worksheets("your worksheet name").Protect Password:="your password" "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''. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto-Protect Sheet on Open and on Close
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''. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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''. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to setup a excel sheet to be protect after save and close file | Excel Discussion (Misc queries) | |||
Can I protect a document and still open / close groups | Excel Worksheet Functions | |||
Auto Open, Refresh, Save, Close | Excel Discussion (Misc queries) | |||
auto open, auto close | Excel Programming | |||
auto close while MsgBox is open | Excel Programming |