I've written some procedures who are called by the worksheet_changed event. I'm having problems with these events. Often they won't work no more and I don't know what could be the problem. Only when I close excel I can get them to work again. Even after just closing the I file it doesn't work. Can anyone help me please?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel Sometimes doesn't call events... why
- Thread starter airtabaki
- Start date
Not sure on this one. I use excel 2000 and tried the code below in a worksheet.
Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox "Worksheet_Change event triggered"
End Sub
Everytime I change the woksheet the message is triggered. What version of Excel are you running?
Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox "Worksheet_Change event triggered"
End Sub
Everytime I change the woksheet the message is triggered. What version of Excel are you running?
- Thread starter
- #3
could be a number of things. Most likely is somewhere yo have
Application.enableevents = false
to allow you to enter data onto a worksheet which has a change event, without firing it. Then, you either don't turn 'em back on again or the code is bombing and the line which turns 'em on again isn't being processed
Rgds, Geoff
[blue]Experience is something you don't get until just after you need it[/blue]
We want to help [red]you[/red] Help us by reading this FAQ 1st faq222-2244
Application.enableevents = false
to allow you to enter data onto a worksheet which has a change event, without firing it. Then, you either don't turn 'em back on again or the code is bombing and the line which turns 'em on again isn't being processed
Rgds, Geoff
[blue]Experience is something you don't get until just after you need it[/blue]
We want to help [red]you[/red] Help us by reading this FAQ 1st faq222-2244
- Status