Getting Cell Address of Locked Cell on Protected Sheet

[LJMetzger]

Problem:
Double Click' gets address of the most recent active cell when a Sheet is protected and 'Select Locked Cells' is NOT checked, and NOT the address of the LOCKED CELL if a LOCKED CELL is 'Double Clicked'.

Solution:
The following code (included in the attached sample file) seems to solve the problem using Api function GetCursorPos().

Sheet module code:

Please Login or Register  to view this content.

Ordinary module code:

Please Login or Register  to view this content.

Lewis