Saving Excel macros on a network

[Janet Braune]

I know that global macros are saved in Personal.xls, which is always
loaded when Excel is opened, but I'm not sure what happens when that
Excel file is then saved on a network, so mutiple users can access
it. If the XLSTART folder is on the C: drive, where is Personal.xls
saved when the file is on a network.

How can Excel users both have use of global macros in Excel files on a
network, and also save their own global macros.

Can anyone help.

 

[Bob Phillips]

Janet,

I am not sure what you mean by '... what happens when that Excel file is
then saved on a network, so multiple users can access it. If the XLSTART
folder is on the C: drive, where is Personal.xls saved when the file is on a
network...', but as regards to the other part, if you go into
Tools>Options>General, you will see there is an alternate startup location
ther where you can specify a network drive. It will load all files in that
drive on startup then.

Or you could investigate an addin to hold macros and distribute to users.


--

HTH

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