keystroke for paste link function
Posted by Anne on December 10, 2001 1:07 PM
I use the paste link function very regularly, is there a way to make a keystroke (I.E. ctrl P) to replace
edit>paste special>paste link ?
Any help would be GREATLY appreciated. Thanks
Posted by Dan on December 10, 2001 1:31 PM
record a macro
You can record a macro that does that function, and assign it a keystroke. Reply back if you need further explanation.
Posted by Anne on December 10, 2001 1:52 PM
Re: record a macro
I tried a macro, but the way I was trying to set it up, it was copying the same cell. I use the paste link function with many different cells.
Any suggestions?
Posted by Anne on December 10, 2001 1:52 PM
Re: record a macro
I tried a macro, but the way I was trying to set it up, it was copying the same cell. I use the paste link function with many different cells.
Any suggestions?
Posted by dan on December 10, 2001 8:13 PM
Re: record a macro
u probably have it set to record an absolute reference. After creating macro, try going to view > toolbars > stop recording and click the relative reference button before you start processing your macro.
