Can not comment on Vista. An operating system should not affect your
code, unless the FSO has to deal with security issues in Vista. Only one
way to find out - do a Google Groups search for the same question.

Office 2007 runs my VBA code without problems, even the custom menus I
create. You might have to select "Compatibility Mode" to get custom
menus to work.