Hi SitCFanTN,

I would suggest that you save the macros in an add-in and distribute the
addin.

See Jan Karel Pieterse's excellent tutorial at:

http://www.jkp-ads.com/Articles/DistributeMacro00.htm

The tutorial also includes an installation programme, which you can see in
operation by downloading any of JKP's add-ins (free of charge) from:

http://www.jkp-ads.com/Download.asp


---
Regards,
Norman


"SITCFanTN" wrote in message
...
I'd like advice on the best way to save a group of macros for a specific
report on about 8 separate PC's used by 8 separate people. Each of these
folks will need to run this report on a daily basis. I was thinking using
the Personal workbook might not be best because if I have to edit the
macros
for one reason, I would have to do it on all 8 PC's right.....I'm new at
this
so any advice you can give is certainly appreciated. Thank you.