Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workgroup Macro? Auto-Update?
I have set a department up with Vista and Office 2007. I have added their
macro's to the Personal.xlsb file in XLSTART folder and added to their Quick Access Toolbar. I was curious if there was a way to have the macro's update from a central location so if we change they all get the newest version? Would prevent me from having to touch each machine to deploy the new Personal.xlsb and possibly removing any custom macro's they have added. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workgroup Macro? Auto-Update?
Save the macro file as an Add-in. *.xlam
Place it in a central folder that all users can access under Add-ins Gord Dibben MS Excel MVP On Fri, 13 Feb 2009 08:52:03 -0800, Joshua wrote: I have set a department up with Vista and Office 2007. I have added their macro's to the Personal.xlsb file in XLSTART folder and added to their Quick Access Toolbar. I was curious if there was a way to have the macro's update from a central location so if we change they all get the newest version? Would prevent me from having to touch each machine to deploy the new Personal.xlsb and possibly removing any custom macro's they have added. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Auto-update of data labels | Excel Worksheet Functions | |||
Stop auto update of filter macro? | Excel Programming | |||
Need an auto update formula macro | Excel Programming | |||
Excel Macro - Auto Update Links | Excel Programming | |||
Auto refresh and DDE update is not work when running macro | Excel Programming |