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