How about this:

Range("a1").Copy
Application.CutCopyMode = False

When I added that extra line, the paste option was gone from the rightclick
menu.

But if I only had application.cutcopymode = false, then it was still enabled.


Kyoux wrote:

It does not solve anything because now, the clipboard has
an empty cell (so once it is pasted, it overwrite the
rest).
Isn't there a way to empty the clipboard by VBA code?
-----Original Message-----
Try .. Range("A1").Copy



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from
http://www.ExcelForum.com/

.


--

Dave Peterson