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.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/