Ambiguous name detected: Worksheet_BeforeDoubleClick

hi all

Im having trouble with the follow error 'Ambiguous name detected: Worksheet_BeforeDoubleClick' I am trying to build a macro so that when i click on cell D6 macro1 runs & then when I click on D7 another macro runs.

Below is the code that I wrote, does anyone know how to incorporate both codes so that I dont have the above error coming up? Please remember I do not want both macros to be run at the same time - I only want one macro to run when a particular cell is double clicked

Please Login or Register  to view this content.

Thanks in advance

Hi,

You can't have two procedures with the same name. Neither can you manually write procedures like sheet event procedures.

You need to use code like

Please Login or Register  to view this content.