In general, what yuo'd want to do si set up a global variable which
flags that the macro was called and set that within the macro code
e.g. gbCalledFromMacro = True). Now, in the code behind your
Slectoin_Change() event, add code like the following:

Selectcion_change()

If (gbCalledFromMacro = True) Then
gbCalledFromMacro = False
Exit sub
End if'

' implied else
' Your normal goes code

End sub

HTH / Tyla /


On May 2, 8:12 am, sgl wrote:
Hi all your assistance please ...,

I have a Selection_Change event in a particular wks. I also have several
Macros for expanding/hiding rows and columns in the same wks. How can I
'SKIP' the Selection_Change event when I trigger one of these macros but
have the Selection_Change event work correctly if the Macro is NOT triggered.

Many thanks in advance/sgl