transfer macros to new compuer

[hurricanesue]

I copied my worksheets from my old computer to my new one but my macros did not come with worksheets...how do I get the macros to the new computer?

[Andy Pope]

If you macros are in a personal workbook then this explains how they work and where you will find them.
http://office.microsoft.com/en-gb/ex...102174076.aspx
http://wheatblog.com/2011/08/where-i...kbook-located/

[hurricanesue]

thanks Andy but neither explained how..jeff

[Andy Pope]

you simply need to locate the file on your old pc and put it in the folder on the new pc

you might also want to then save it in the newer file format.