Accessing macro from a system by all other nodes on LAN

[NSNR]

I have created a macro in a worksheet and stored in C:\program
files\MSOffice\Office10\XL Start folder. Now I want to execute the macro
whenever MSExcel is started from, the system on which it is stored and also
on other systems in the network.
Request to guide me in solving the above query. Any changes to the macro
shall be made only in the system where it is stored.

NSNRao

 

[Dave Peterson]

First, don't name your macro workbook personal.xls.

Give it a nice unique name: NSRUtils.xls

Then distribute it to your coworkers and tell them to put it in their XLStart
folder--if you really want them to be able to update the macros in that workbook
(I'm confused about what a system is in your post).

If you want to be the only person who updates the workbook, then save the
workbook as an addin, mark it readonly and store it on a common network drive.

Tell the other users that they should use tools|addins and browse to that
location using the UNC path--not the mapped drive letter--to install it.

But once you save the file as an addin, the macros won't appear in the
Tools|Macro dialog. You'll need to provide an interface for the users so that
they can run your macros.

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an
addin)
or
http://www.rondebruin.nl/2007addin.htm

In xl2007, those toolbars and menu modifications will show up under the addins.