Hi, Steve@TRW,
you´re correct about the non existence of s BeforeLeftClick-event but I´m afraid VBA alon will only get hold of the cell being selected and not how that is being done: mouse, cursor, tab.
Running the code may be either done by unprotecting the worksheet prior to action and protecting it again at the end of the procedure or by using the Protect-Command with parameter UserInterfaceOnly:=True which is a volatile setting that is not saved with the workbook and should be set each time when opening the workbook.
Ciao,
Holger
Bookmarks