including a macro in all workbooks
 

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

including a macro in all workbooks
 

Matt,

Store the code in your Personal.xls

HTH,
Bernie
MS Excel MVP


"MJKelly" wrote in message
...
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

including a macro in all workbooks
 

Thanks,

What directory am I likely to find that spreadsheet?

Matt

including a macro in all workbooks
 

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" wrote in message
...
Thanks,

What directory am I likely to find that spreadsheet?

Matt

including a macro in all workbooks
 

Thanks for that - all done.

Matt