Double Click Macro - multiple ranges with different outcomes?

Hi all,

I'm after some help please on if/how I can use the 'Worksheet_BeforeDoubleClick' for two different named ranges with a different outcome on each. For the first range (Signature), I have a simple user ID entry. I then have a second range (Signature_2) which requires a user ID entry plus to copy and paste special that selected row and set font colour to black (as this cell to be 'signed' is at the end of the row once all actions taken).

I so far have the following:

Please Login or Register  to view this content.

plus a separate section for the second range:

Please Login or Register  to view this content.

any ideas please?

many thanks

Hi davesexcel,

thank you, I have added this in and from my perspective this should be working (see below), however when I double-click a cell in the "signature" range, it is carrying out the "signature_2" actions, whilst double-clicking "signature_2" is doing nothing.... any thoughts?

Please Login or Register  to view this content.