Pam

The macro can be stored in your Personal.xls or an Add-in in
order for it to be available for all your Excel Workbooks.


Gord Dibben Excel MVP


On Thu, 21 Jul 2005 08:16:04 -0700, "Pam Coleman"
wrote:

If I create a macro on my PC to format a text file that is being brought over
to excel on a weekly basis (and it is saved in a file on our server), can the
macro be saved so that every week when someone else opens up a new file, the
macros can run to format that file? Sometimes I notice when you create a
macro in your workbook on your PC, it does not show in other excel
workbooks. Thanks,