You are all fantastic. Never had so many positive replies so fast. All of
them worked.Thank you all/sgl

"Dave Peterson" wrote:

Disable events in your code, do the work, then turn on that even handling:

Application.enableevents = false
'your code to add/delete/hide rows or columns
application.enableevents = true



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

--

Dave Peterson