Distributing Macro's and Personal.Dot files

[Guest]

We have sales folks with laptops wit varying degree's of skill with Excel.
Some have their own macro's and some don't. If I have built a macro that
they all could use - what is the easiest way to distribute the macro to them
without overwriting their existing macro's. These folks are not as computer
literate so it needs to be very "hands off".

 

[Dave Peterson]

If you're going to share these utilities with others, you won't want to use the
name personal.xl*.

Use a name like: JayUtils.xls or JayUtils.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