Todd,

modifying someone elses personal.xls file is not really sound practice. If
you want to distribute your code you would be better off saving your own
personal.xls under a new name as an addin, then distributing that to your
audience. They can then load the addin and control whether they want your
code loaded or not.

You may also find that attempts to modify personal.xls run into security
problems depending on the users security settings. They may not want to
trust you as a source, may have security set to high, or may have disabled
access to vb projects, all of which would result in errors.

Robin Hammond
www.enhanceddatasystems.com


"Todd Huttenstine" wrote in message
...
Hey guys

I have a code in my Personal.xls module that I would like
to put on alot of other peoples computer. Is there anyway
to do this without having to mannualy do it? Now Bob
Phillips game me the link to Chip Pearsons website
http://www.cpearson.com/excel/vbe.htm
that allows you to update code on the fly, but I have been
unable to go to that site since I am at work(behind
firewall). I will have to do this when I go home. Im not
sure if this will also work for my issue with Personal.xls.

Any help is appreciated.

Thanx
Todd Huttenstine

Thank you