Worksheet_SelectionChange won't work with Protected Sheet

[LuisV805]

The event is triggered just fine when the worksheet is not protected. When I protect it, however, this event is no longer being triggered. Nothing else has changed. Is this how Excel is supposed to work? Not sure if I'm missing something here...

 

[Fluff]

SelectionChange works on protected sheets.
Do you have any unlocked cells & when protecting the sheet did you allow "Select locked cells"

 

[LuisV805]

Yes, I left some cells unlocked. "Select Locked Cells" is turned off. I don't want the user to be able to selected Locked Cells. I can change the selection while the sheet is protected though, but the event is just not triggering.

I tried using a breakpoint to stop the code on the sub's first line, but it's not stopping on it.

 

[Fluff]

Put this in a standard module & run it

Sub chk()
Application.EnableEvents = True
End Sub

Then try you selectionchange event again

 

[LuisV805]

I checked and Application.EnableEvents was still set to True. I ran the sub you mentioned anyways just for kicks, but with the same results. Also confirmed the Worksheet_Change is firing without any issues either. Not sure why, but looks like this is normal Excel behavior.

I was able to work around the issue, though. by protecting the sheet programatically, I can set UserInterfaceOnly to True. Doing this allows the event to trigger as normal without any issues.

Hope this helps if anybody runs into the same issue!

 

[Fluff]

Glad you got it sorted & thanks for the feedback.