Worksheet Events Not Working Consistenly

**incjourn** · 01-07-2009, 07:08 AM

All,

I have been working with Worksheet_SelectionChange and Worksheet_Change events. They start of working and then they stop, sometimes after a de-bug and sometime after a change on the worksheet. If I save and close the workbook and open it again it is fine. Can anybody tell me what is happening and suggest a fix?

An example of my code...

Please Login or Register  to view this content.

**mudraker** · 01-07-2009, 07:27 AM

Did you copy & paste the code into your posting or type it in

Your posted code has a couple of errors init that will cause it to error & not run at all

Please Login or Register  to view this content.

should be

Please Login or Register  to view this content.

Please Login or Register  to view this content.

should be probally be

Please Login or Register  to view this content.

Not shure what you are trying to do with using Name twice

Please Login or Register  to view this content.

**royUK** · 01-07-2009, 07:35 AM

You also need to add On Error GoTo 0 at the end to return error handling to Excel

**romperstomper** · 01-07-2009, 08:02 AM

If you Debug and press Stop, your code will not run to the end and events will be disabled. Restarting Excel will reset that.
You would only use On Error Goto 0 if you wanted to disable all error handlers, which is presumably not the case here.

**incjourn** · 01-08-2009, 05:50 AM

Thaks that's helpful.
Is there any other way to reset the events without closing and opening the workbook?

**romperstomper** · 01-08-2009, 05:57 AM

Yeah you can just type:

Please Login or Register  to view this content.

in the Immediate Window and press enter. I have two one-line subs for turning events on and off when I'm debugging.

Worksheet Events Not Working Consistenly

LinkBack

Thread Tools

Rate This Thread

Display

Worksheet Events Not Working Consistenly

?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions