Sheet Protection interfears with Change event

[bdouglas1011]

Why does a worksheet change event not work if the sheet is protected but the cell that the event is running in is not a protected / Hidden cell.

[JBeaucaire]

You will have to update your protection to include the UserInterfaceOnly:=True parameter. This parameter must be reset each time you open the workbook, it doesn't "persist".

Once you have reset the protection to include that parameter, your macros will continue to work.

[bdouglas1011]

how would I add that here is the code

Please Login or Register  to view this content.

[JBeaucaire]

Nowhere. You need to create a macro to reapply the protection to your sheet when you first open your workbook. You can put it into a Workbook_Open() event in the ThisWorkbook module so it runs automatically when the workbook starts. This is where you will add the UserInterfaceOnly:=True option to the regular protection code.