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