Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,564
- Office Version
- 365
- 2016
- Platform
- Windows
With the exception of a couple ranges of a worksheet, that worksheet's cell are locked and the sheet protected.
I have noticed though, is that if a user double clicks on a locked cell, Excel seems to assume the user has double clicked on the closest unlocked cell. My unlocked cells have doubleclick actions associated to them, so when Excel executes an indirectly double clicked cell (ie user doubleclicks a locked cell), all hell breaks loose. Code is being run when it shouldn't.
How can I avoid this happening?
I have noticed though, is that if a user double clicks on a locked cell, Excel seems to assume the user has double clicked on the closest unlocked cell. My unlocked cells have doubleclick actions associated to them, so when Excel executes an indirectly double clicked cell (ie user doubleclicks a locked cell), all hell breaks loose. Code is being run when it shouldn't.
How can I avoid this happening?