How can I run VBA Worksheet_BeforeDoubleClick on a (new) daily extract.csv

[p45cal]

Well it sure works

Good, that puts this to bed:

attempted to double clicked within the range G2:G1000 and nothing happens

only snag is I and users double click on any workbook sheet and it put the time in, which is not so good

Well, my last message was a debugging exercise; I did say:

That's enough to be getting on with - come back and tell us how you get on.

I know the name of the workbook.sheet.csv that I need this to work on and would really like it to only work for that workbook_name. sheet1Name

and:

can this code you gave be amended to only work on a named worksheet like the other macros

Of course it can. If the name of the sheet is invariable, tell us what it is. If it isn't (and I suspect this is the more likely scenario) then tell us what parts of the sheet name do remain constant and which parts are variable and how they may vary. Also, while the sheet name may be enough, in order to make the code really only work when you want it to, we could probably treat the file name in the same way, so some accurate and comprehensive information from you on the file names and sheet names is required.

I may not respond today.