Code stops working until I reboot

**AndrewMac** · 01-15-2013, 01:20 PM

I have some code for a Worksheet Change event that works fine enough until I start making a few changes to the workbook (unrelated to the code) and then it stops responding. It starts working again when I rename the file and reload it. Any ideas what might be causing this would be appreciated?

**patel45** · 01-15-2013, 03:45 PM

I saw your code into my crystal ball, it is wrong, error in line 17.

**jaslake** · 01-15-2013, 05:41 PM

@patel45

Ha...I was thinking the same...my ball was cloudy...couldn't tell which line of code was throwing the error...good work!

**AB33** · 01-15-2013, 05:47 PM

Hi John,
It is me again

Here is the link to thread. I was also invloved with this thread. The code seemed to work, but was unable to help Andrew further. You may come up with a solution, or an idea. I think Andrew should have linked the threads

http://www.excelforum.com/excel-prog...nge-event.html

**jaslake** · 01-15-2013, 06:01 PM

@AB33
I assumed from the OP's Name the OP is working on a Mac...probably a bad assumption...I'll look at it a bit.

**AB33** · 01-15-2013, 06:11 PM

John,
You have seen what I did not, this is what makes this forum great. I think if he has a Mac, you are right and do not know how things work with Mac.
Thanks again!