One thought is to create an add-in that contains your macros. Add-ins can be
used by many at the same time. Put the add-in on the server and have your
clients put the add-in into their add-in library [ToolsAddins].
Then you only have to update the one Addin file on the server and all your
clients have it next time they load Excel.
--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"leungkong" wrote:

I want to know how to put the VBA on server for easy maintain.
since the file will be used by lots of user.
If the file is needed to maintain, I need to copy the VBA in every excel
file now.

Can I set up the file to get the VBA from server when I run the Macro?