Workgroup Macro? Auto-Update?

  • Thread starter Thread starter Joshua
  • Start date Start date
J

Joshua

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Personal.xlsb in Excel 2007 stopped being open at start 3
Excel 2007, Automatically open new worksheet on open. 4
How do I create Personal.xlsb 6
Excel 2007 - Macro Not Available 3
Personal.xlsm 11
excel macro buttons created on quick access toolbar wont work 1
How to call Excel add-in macro from a button… 1
Personal.xls Issues in Excel 2007 1

Back
Top