Link to macros (personal) on server

  • Thread starter Thread starter seta
  • Start date Start date
S

seta

Is there a way of putting the file (e.g., PERSONAL.XLS) that contains
commonly used set of macros on the server and create a link (shortcut
in the startup folder (on each separate user's PC). I have tried th
following: (1) put PERSONAL.XLS on the the server (2) created
shortcut (3) coppied the shortcut into the Excel startup folder. Thi
did not work (regardless of whether I rename the "shortcut t
PERSONAL.XLS" to just "PERSONAL.XLS" in the startup folder. NOTE:
realise that it is possible to select the file on the server each tim
but that would be painful. Cheers
 
If you're going to share these utilities with others, you won't want to use the
name personal.xl*.

Use a name like: SetaUtils.xls or SetaUtils.xla

If you use the name personal.xls, then that name may conflict with their own
personal.xls workbook. (Excel can only have on workbook with that name open at
any time.)

You may want to consider saving it as an addin. The the you can put that addin
on a nice common folder and tell the users to use:

Tools|addins|browse|point at your addin workbook.

To install it.

If you save your workbook as an addin, you'll have to give the user some way to
run the macros...

Here's how I create that toolbar on the fly:
http://groups.google.co.uk/[email protected]

If you want to add items to the worksheet menu bar, you can use John
Walkenbach's menumaker:
http://j-walk.com/ss/excel/tips/tip53.htm
 
Back
Top