Thread: Macro button needed to paste link

Hi,

I would like a simple macro to 'Paste Link' under the Paste Special function in Edit. I would like to assign it to a button also as I have a repative task to copy from one workbook and to paste link into a seperate number of workbooks. This way I can just hit a button once I have copied a selection.

Please may you guide me into how to create this macro.

thanks in advance!

KB