Many thanks, I tihnk I may have over explained my needs.

My question, situation and code was/is not meant to be complex.

Put real simply, All I wanted was for my user/s to be able to DBL_click a range on a specific (Constant) named (workbook > sheet1), and insert the current time within that range specified, and a way of checking if its not the target workbook>sheet than exit & do nothing.

but since many users can run the same report, I guessed each user would need the VBA code would need to reside in their personal.xlsb
(Thats it!)


But, In all the macros I written though, I'd never really came across a situation on how to call an event macro for example calling a sub before doubleclick from the personal.xlsb to run on a new daily Exported CSV.

I didn't think it would be this complex to do as it seems rather alot