Worksheet_SelectionChange stops working

  • Thread starter Thread starter jlr_nz
  • Start date Start date
J

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.
 
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.
 
Back
Top