ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Paste Options (https://www.excelbanter.com/excel-programming/373105-paste-options.html)

kirkm[_6_]

Paste Options
 

Help ! After pasting something in, how do you get rid
of the Paste Options icon and the moving marquee around the cell?

It's done all I want it to but has this thing there now - presenting a
list of options, none oif which I want and no way to exit.

Thanks - Kirk

NickHK

Paste Options
 
Kirk,
Application.CutCopyMode=False, to remove the marquee.
Not sure what you by "Paste Options icon" ?

NickHK

"kirkm" wrote in message
...

Help ! After pasting something in, how do you get rid
of the Paste Options icon and the moving marquee around the cell?

It's done all I want it to but has this thing there now - presenting a
list of options, none oif which I want and no way to exit.

Thanks - Kirk




Zilbandy

Paste Options
 
On Mon, 18 Sep 2006 21:48:14 +1200, kirkm
wrote:

Help ! After pasting something in, how do you get rid
of the Paste Options icon and the moving marquee around the cell?

It's done all I want it to but has this thing there now - presenting a
list of options, none oif which I want and no way to exit.


Have you tried hitting the Esc key?

Jim Rech

Paste Options
 
You have to "do something" in the sheet. Pressing F2 and Enter seems to
quality.

--
Jim
"kirkm" wrote in message
...
|
| Help ! After pasting something in, how do you get rid
| of the Paste Options icon and the moving marquee around the cell?
|
| It's done all I want it to but has this thing there now - presenting a
| list of options, none oif which I want and no way to exit.
|
| Thanks - Kirk



kirkm[_6_]

Paste Options
 
On Mon, 18 Sep 2006 03:39:33 -0700, Zilbandy
wrote:


Have you tried hitting the Esc key?


No but I'll remember that for next time. Went to
save and Exit and that got rid of it also.

Thanks - Kirk


All times are GMT +1. The time now is 05:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com