Greg, Dian, Linda, I was referring to both Word and Excel, but mostly Excel. These are not things I've needed before recently, as my uses (especially with Excel) increase. Thank you all for your answers. I'm going to try them tomorrow. Pam -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On Behalf Of Dian Chapman Sent: Sunday, September 21, 2003 11:26 PM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: macros You stick them all in one template and have users put that template in their .../word/startup directory to make it available for all. If you'd prefer to have them in ONE place, versus on each system, you need a network shared drive. Then put it in there and tell everyone to click Tool/Options/File Locations and set their WORKGROUP TEMPLATES path to that network drive. Dian D. Chapman Technical Consultant, Microsoft MVP & Instructor Free Tutorials: www.mousetrax.com/techtrax Free Word Tips & Tricks eBook: www.mousetrax.com/books.html Learn VBA the easy way, thru video! www.mousetrax.com/techcourses.html -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Pam Sent: Sunday, September 21, 2003 11:04 PM To: MicrosoftOffice Subject: [mso] macros Is there a way to store macros that might be used in lots of applications in a central place so that they are available to you in any document you are in? Pam ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************