I want to install a macro so that it can be used by all workbooks. I know
that if I record a macro I can save it in personal.xls which would allow me
to do this, but if I am installing a macro in VB Editor using copy and paste,
how do I set it up so that it can be used by all my workbooks. Thanks in
advance

hi,
Install it in the vb editor of personal.xls.

-----Original Message-----
I want to install a macro so that it can be used by all
workbooks. I know
that if I record a macro I can save it in personal.xls
which would allow me
to do this, but if I am installing a macro in VB Editor
using copy and paste,
how do I set it up so that it can be used by all my
workbooks. Thanks in
advance
.

Create and addin with a public method for your macro then save the
addin to 'c:\Program Files\Microsoft Office\Office\Library' or
something similar then goto Tools .. Addins in the main Excel menu and
tick your new addin. This macro will then be accesible from all other
workbooks.

Mark