Macro doesn't run under Vista

[Dave.Punk.Emo]

I've written a nice little set of macros in Excel 2003 which run
flawlessly on XP (tested on multiple XP machines), but freeze up as
soon as I click run on a vista machine.

Is this just a Vista thing??

 

[Mike Fogleman]

That depends mostly on the version of Office that is running on Vista.
Office 2003 on Vista OS not so much a problem. The problem is the changes
made in Office 2007 being compatible with older versions. Even if you Save
As an older version, it only makes the Workbook compatible, not the code you
have written. I know 3 people at work who got Office 2007 on new Vista
machines and uninstalled it in favor of Office 2003. I have not tried the
new Office 2007 yet just because of what I hear about those who have.

You will need to do some macro modification if you stick with 2007, and some
version trapping to run the correct code for whichever version the user is
running.

Good Luck!!
Mike F