I'm generally a novice when it comes to excel, but I've been learning a lot more on VBA and have been going back and cleaning up some macros that I have used for a long time (and originally where just recorded). After making some tweaks to the macro below, I have the problem listed in the header. Once it starts to run if I sit there and do nothing, the macro loops through the sheets fine. However, If I go to click on a shortcut in my quick launch, it freezes and stops working. This sounds a lot like an excel bug to me, but I thought I'd check to see if anyone can see anything in the macro that may be causing this:
Also, just to note, I don't see the same issue in Excel 2003
Bookmarks