I'm stuck. I can't find a way to protect my sheet while allow users to double click in a cell, use data validation list in the same cell while protecting shapes from being edited.
When I set DrawingObjects:=True the shapes are protected but I can no longer double click in a cell that has a data validation list in it.
When I set DrawingObjects:=False that is the only way I can get the double click to work in a cell with data validation but then my shapes can be edited
I created a macro on my shapes that shifts focus off of it which works for any left click efforts on the shape but all the right click functionality is still there.
I also created a macro that changed the protection settings when a cell that I needed to double click and have validation was selected but that logic doesn't really work because single clicking in the cell makes the shapes editable again. So I set a timer that when a doubleclick+validation cell was selected it would wait, doevents, then set back the fully protected settings but it was clunky.
Can someone help me with a way to pull this off?
When I set DrawingObjects:=True the shapes are protected but I can no longer double click in a cell that has a data validation list in it.
When I set DrawingObjects:=False that is the only way I can get the double click to work in a cell with data validation but then my shapes can be edited
I created a macro on my shapes that shifts focus off of it which works for any left click efforts on the shape but all the right click functionality is still there.
I also created a macro that changed the protection settings when a cell that I needed to double click and have validation was selected but that logic doesn't really work because single clicking in the cell makes the shapes editable again. So I set a timer that when a doubleclick+validation cell was selected it would wait, doevents, then set back the fully protected settings but it was clunky.
Can someone help me with a way to pull this off?