Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF just STOPS WORKING | Excel Worksheet Functions | |||
Vlookup stops working??? | Excel Worksheet Functions | |||
VLOOKUP stops working at row 13 | Excel Worksheet Functions | |||
Autofilter Stops Working | Excel Worksheet Functions | |||
Worksheet_SelectionChange not working | New Users to Excel |