install a macro for all workbooks

[Guest]

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

 

[Guest]

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

 

[MarkHG]

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