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''.