Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving Excel macros on a network
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving Excel macros on a network
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 ToolsOptionsGeneral, 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) "Janet Braune" wrote in message om... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving Excel File to a Network Drive | Excel Discussion (Misc queries) | |||
Excel Slow saving across Network. | Excel Discussion (Misc queries) | |||
problem saving excel file on a network | Excel Discussion (Misc queries) | |||
new excel files not saving across wireless network | Excel Discussion (Misc queries) | |||
Sharing Excel File on Network - Saving | Excel Programming |