Worksheet_SelectionChange stops working
 

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/

Worksheet_SelectionChange stops working
 

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.

--
Regards,
Tom Ogilvy

jlr_nz wrote in message
...

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/

Worksheet_SelectionChange stops working
 

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

--
Don Guillett
SalesAid Software

"jlr_nz" wrote in message
...

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/