All my macros have suddenly started crashing Excel 2007 when I try to run any one of them. I can record a new macro but even that newly recorded macro will crash Excel.
Service Pack 1 was downloaded and installed by Windows Update two days ago and I had successfully run macros after SP1 was installed.
Today, it's a no go and I'm at a loss as to what may have caused this problem. I have not installed any software lately, other than the Windows updates on patch Tuesday.
This is on a Vista Home Premium machine.
When I try to run a macro, Excel crashes with this info:
I also get a MS Visual Basic dialog saying an automation error exception occurred. Excel will not close until I click the OK button on this dialog.
I've been searching for a solution all morning with no luck. Any ideas on what may be causing this problem? I am doomed without these macros!
Thanks in advance.
Steve
Bookmarks