Look at add-ins.

http://support.microsoft.com/?id=167909
XL: Securing Visual Basic Code in Microsoft Excel

http://support.microsoft.com/?id=156942
XL97: How to Create an Add-in File in Microsoft Excel 97

http://support.microsoft.com/?id=211563
How to create an add-in file in Excel 2000

and see Jan Karel Pieterse's tutorial at:

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"jnewl" wrote in message
...
how does the personal.xls file get updated?

i thought everytime i made a change in excel macros that the personal file
was updated. i discovered today that is not true.

how do i control where the file can be located? want to put a common
macro
library on the server for several people to use
how do i ensure that the file is updated correctly?

thanks