Special Paste changing default preference...help a chef out.

[ExecChef]

When linking inside Word or from Word to Excel or Excel to Excel after highlighting what I want linked and moving to where I want it to link I click paste specail.
The problem I have is the default is set to Paste not to Paste link so each time I have to click on Paste link. I need to do a lot of linking and would like for the default to be Paste link. Does anyone know how I can do this. Thanks ExecChef

 

[donna6197]

For Word, how about a keyboard shortcut that runs a macro similar to following:

Sub PasteSpecialLink()
Selection.PasteSpecial Link:=True, DataType:=wdPasteOLEObject
End Sub