Protect Sheet

[Taurus]

Hello,

I am running into a problem after I saved the protected worksheet.

Before I save the report, user are not allow to click on the cells or
fields that is protected.
After I save it, and re-open the xls, user is allow to click on the
cell or field that is protected but is not allow to edit. Is that the
behaviour of the excel?

I am using the below syntax:
ActiveSheet.Protect Password:="585", DrawingObjects:=True,
Contents:=True, Scenarios:=True
ActiveSheet.EnableSelection = xlUnlockedCells

Did anyone has the same issue?

 

[JE McGimpsey]

ActiveSheet.EnableSelection = xlUnlockedCells

Did anyone has the same issue?

Yes. EnableSelection isn't saved with the workbook. You need to set it
every time the workbook opens. Put something like this in the
ThisWorkbook module:

Private Sub Workbook_Open()
Sheets(1).EnableSelection = xlUnlockedCells
End Sub

 

[Taurus]

Thank you so much. It works!