Can I use one macro in multiple computers simultaneously?

[TBailey]

I have 13 areas that use the same macro that is currently saved in the workbook on the company drive. Every time I make a change to how the macro performs certain tasks I must change it on 13 separate computers. What I would like to do is save the macro in one place and access it with multiple computers – is this possible?

 

[jproffer]

You can leave it in the workbook that is saved on the company drive, as long as the users access the WB FROM the company drive. Meaning they don't copy it to their machine.

Or you can create a workbook on the public drive, similar to the Personal Macro Workbook, and tell each user to make that a start up file.

Or you can create an add-in and store it on the public drive as long as it's accessed as mentioned above and not copied to each machine.

 

[TBailey]

How do I create an add-in and save to the public drive?

 

[jproffer]

SaveAs xlam

But you'll also have to make a menu, since the normal macros window won't show macros from add-ins.

What version of excel are you using?

 

[TBailey]

2010

 

[jproffer]

Ok, couple options:

1) Learn how to create a ribbon menu.

http://www.rondebruin.nl/ribbon.htm
http://msdn.microsoft.com/en-us/library/dd756403(v=office.12).aspx

those are 2 good sites to get you started. Google will turn up about 1000 more


2) Create a regular (pre-07) excel menu and when it loads the menu will be in the Add-ins tab of the ribbon.

http://spreadsheetpage.com/index.php/file/menu_maker/

That is the easiest to use, and easiest to modify, menu maker I've found out there.