Worksheet_Change Problem

[WernerLouw]

Hi,

I have various wbk's and sheets running with a set of macros, One macro opens the next sheet which then updates data closes the sheets etc. I then have a worksheet_change sub, which has worked fine in the past... but every now and then it doesn't...

It seems that the pc's memory is exhausted... The macro just does not want to run. I then have to close everything and restart excell to get the macro to work, but this does not always help the forst time... All the other marcos do run however while this is happening.


Any help would be greatly appreciated...

 

[Chitosunday]

Maybe in your code you have
application.enableevents=false

You have to reverse it at the end of your macro
application.enableevents=true

 

[WernerLouw]

I did re-enable the events at the end of the sub, what i did not recon with is the fact that i "sometimes" step out of the sub before i re-enable the events...

What I dont understand though is the fact that the other macros, such as my calender control, still worked fine... but it would not update the data, based onthe calender control.

Thanks for the hint anyway...

 

[Chitosunday]

enableevents will just disable events like change of cell data (change_events), opening of files(workbook_open) but your other macro will work for those triggered manually like if you have short-cut key alt-A, or clicking tools, macro , the sub title or branching to other macro.