Worksheet_SelectionChange stops working

[jlr_nz]

i have written a bit of program to do the following,

if the active cell is changed to a cirtain value, say 10,
Worksheet_SelectionChange program changes the colour of a group of
cells and put borders around that group of cells.

when i run a seperate macro which copies values from another sheet into
the active sheet, the Worksheet_SelectionChange program stops
working??

the only way to get the Worksheet_SelectionChange program to start
working again is to save and close xl and open it again.

why does the Worksheet_SelectionChange program stop working and is it
possible to enable it again somehow??

thanks.

 

[Tom Ogilvy]

do you have code that disables events?

this is the most likely scenario. Make sure any code that disables events
enables them again under any situation.

 

[Don Guillett]

You probably should copy/paste your code here for comments.