Some thoughts:
1. You could put the macro in the files that are mailed (Best way).
2. You could send a file with the macro in it and tell the users t
open it before running the print function (may need to change macro fo
this).
3. You could put the macro in a spreadsheet on a shared directory an
set each user's Excel up to open files from this directory when openin
excel (Tools | Options | General, put directory in the At startup, ope
all files in:).
4. You could edit each user's personal.xls (or create if they don'
have one). This would take the longest...
--
Message posted from
http://www.ExcelForum.com