Help - where to put VBCode on a network
 

I want a number of users to be able to use files and access a set of macros
and so I have put the code in a specific file on the server. This file is
called up in the Options/General/Alternate StartUp File Locations. This
works fine but excel then makes this code available for everyother user on
the server with all excel files using this setting which isn't very clever.

How can I make this code available for only my set of users without putting
the code in each seperate file?

Mervyn

Help - where to put VBCode on a network
 

Put it in an addin, and load that addin to selected users.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Mervyn Thomas" wrote in message
...
I want a number of users to be able to use files and access a set of
macros
and so I have put the code in a specific file on the server. This file is
called up in the Options/General/Alternate StartUp File Locations. This
works fine but excel then makes this code available for everyother user on
the server with all excel files using this setting which isn't very
clever.

How can I make this code available for only my set of users without
putting
the code in each seperate file?

Mervyn