Location of Macro Files (personal.xls?) for server application

[John R. Reagan]

How do I set up a common macro location for all users on a server? Everyone should be using this common file rather than there own personal.xls file. Right now if I make a change for one user i have to go to six other machines and make the same changes to maintain configuration.

 

[Dave Peterson]

First a word of warning.

Don't use the name personal.xl*.

Every open file must have a unique name and if your users have a personal.xl*,
then one of the files can't be open.

I think I'd save the file as an addin on a shared drive.
File|SaveAs and then use the "Save as Type" box.
(I'd use windows explorer to mark that file Readonly, too.)

Then have your users install that addin.
Tools|addins

I really like John Walkenbach's MenuMaker for creating a nice access to my
macros.

http://j-walk.com/ss/excel/tips/tip53.htm