Working Code Suddenly Broken: Run-Time Error '32809'

I just upgraded to 2007. I've sucessfully run this macro 100's of times with no problems. Other than upgrading to 2007 I've made no further changes to system or code. Code even worked the day I upgraded, but suddenly today, it doesn't work.

The code is supposed to enable a command button on a sheet. The code is inside that sheets private codes, and I've double and triple checked the naem of my command button.

Please Login or Register  to view this content.

The macro refuses to fire, and everything i've tried to do just puts the runtime error on my screen. Please help with this

Originally Posted by shg

You sure about that? Set a breakpoint, or insert the line Stop as the first line of code, and nothing happens?

Are events enabled?

I've tried clearing everything out and just doing a debug.print and a message box and they wont even fire. Its like worksheet change isn't working. And now if I manually run the macros normally triggered by clicking the disabled buttons, they are failing too... Here is one:

Please Login or Register  to view this content.

And its debugging on line one, just switching sheets with Run-time error '1004' Select mehod of worksheet class failed. Again, these all worked fine, and frequently, on a daily basis for almost a year,and now suddenly no dice.

no dice, and i no longer have excel 2003. I withheld as long as I possibly could, but work forced me. Thing is, this WORKED the other day even in 2007. I just saved it and now its not working suddenly. I dont' even know why it wont switch to "Summary" or "MySummary"

Well I just went into a slightly older version (just a different month - same code) to see if it had the same problem. The Sort button (there are 4 on the page) forced me to change its name due to some ambiguous thing, and I did. The macro runs perfectly on that sheet... I'm at a loss.

and now that i've saved it, its not workign anymore. same errors.

... so I get so frustrated I reboot and take a nap... i come back, and its working properly...

I came across this problem myself and it seems to be a bit random... the sheet/code/workbook (or whatever) somehow gets corrupted.

To fix it, I copied the problematic sheet, deleted the original and renamed the copy back to the original.

(FYI, I am responding to this old thread in case someone else has this problem and needs a potential solution - obviously I cannot guarantee this will work for everyone, but it's always worth a try. )