suspect your "Mr Tom":

Mr. Tom adviced to set the focus to false and did not work.


from the OP's original post in this thead.
--
Regards,
Tom Ogivy


"Tim Williams" wrote:

Did you try my suggestion at your previous post (this appears to be the same
problem).
If you're using a commandbutton to call this code then make sure its
"takefocusonclick" property is set to False.

Tim



"CAPTGNVR" wrote in message
oups.com...
DEAR ALL
What I need is for example to copy contents in say b4.c4 to e4.f4. On
copying I want e4.f4 as a link so that any changes in b4.c4 would
relfect automatically in e4.f4.
So I wrote in VBA and it works fine if I do step by step using F8.
But when run thro the command button the ActiveSheet.Paste Link:=True
fails. Mr. Tom adviced to set the focus to false and did not work.
Pls advice how to achieve this. I will check for response every
30mints. Pls help.