Pam: When you create the macro, make sure you save it in "This Workbook" and
not in your Personal Macro Storage. Please see Step 1, and "Store macro in".
http://www.officearticles.com/excel/...soft_excel.htm

*******************
~Anne Troy

www.OfficeArticles.com


"Pam Coleman" wrote in message
...
Can a macro be created in my excel and then saved to our server on an
excel
spreadsheet. When I create one and then save it, it does not appear when
I
open the spreadsheet on the server. Thanks