including a macro in all workbooks

[MJKelly]

Hi,

I have a simple macro which pastes the values of the selected range
into the activecell, and I have this assigned to a shortcut key. How
do I make use of this macro n all workbooks? i.e. each time I open
Excel, the shortcut ill work for me (wheter its a new workbook or an
existing one).

Many thanks,
Matt

 

[Bernie Deitrick]

Matt,

Store the code in your Personal.xls

HTH,
Bernie
MS Excel MVP

 

[MJKelly]

Thanks,

What directory am I likely to find that spreadsheet?

Matt

 

[Bernie Deitrick]

Matt,

If it exists, it is stored in your XLStart folder.

To create one, record a macro and under "Store Macro in" choose "Personal macro workbook"

Then Excel will put it in your default XLStart folder - it will be opened every time you start
Excel, and you can figure out where it is stored from there.

HTH,
Bernie
MS Excel MVP

 

[MJKelly]

Thanks for that - all done.

Matt