Paste Command
 

I have a script that has the "ActiveSheet.Paste" command
as the last line. When it executes, it leaves the
message "Select destination and press ENTER or choose
Paste" on the bottom left message bar.

I have tried adding statements to move the cursor after
the paste, but the message still appears.

Is there a way to remove this message? I don't want to
confuse the end users of this script.

Thanks.

Paste Command
 

Just a thought, but have you tried adding
CutCopyMode = False
after the paste command?

--
Return email address is not as DEEP as it appears
"Martin" wrote in message
...
I have a script that has the "ActiveSheet.Paste" command
as the last line. When it executes, it leaves the
message "Select destination and press ENTER or choose
Paste" on the bottom left message bar.

I have tried adding statements to move the cursor after
the paste, but the message still appears.

Is there a way to remove this message? I don't want to
confuse the end users of this script.

Thanks.

Paste Command
 

I tried your suggestion, but it did not work.

Thanks.

-----Original Message-----
Just a thought, but have you tried adding
CutCopyMode = False
after the paste command?

--
Return email address is not as DEEP as it appears
"Martin" wrote in
message
...
I have a script that has the "ActiveSheet.Paste" command
as the last line. When it executes, it leaves the
message "Select destination and press ENTER or choose
Paste" on the bottom left message bar.

I have tried adding statements to move the cursor after
the paste, but the message still appears.

Is there a way to remove this message? I don't want to
confuse the end users of this script.

Thanks.



.

Paste Command
 

hi,
application.cutcopymode = false should do it.
-----Original Message-----
Just a thought, but have you tried adding
CutCopyMode = False
after the paste command?

--
Return email address is not as DEEP as it appears
"Martin" wrote in
message
...
I have a script that has the "ActiveSheet.Paste" command
as the last line. When it executes, it leaves the
message "Select destination and press ENTER or choose
Paste" on the bottom left message bar.

I have tried adding statements to move the cursor after
the paste, but the message still appears.

Is there a way to remove this message? I don't want to
confuse the end users of this script.

Thanks.



.

Paste Command
 

That did the trick. Thanks.


-----Original Message-----
hi,
application.cutcopymode = false should do it.
-----Original Message-----
Just a thought, but have you tried adding
CutCopyMode = False
after the paste command?

--
Return email address is not as DEEP as it appears
"Martin" wrote in
message
...
I have a script that has the "ActiveSheet.Paste" command
as the last line. When it executes, it leaves the
message "Select destination and press ENTER or choose
Paste" on the bottom left message bar.

I have tried adding statements to move the cursor after
the paste, but the message still appears.

Is there a way to remove this message? I don't want to
confuse the end users of this script.

Thanks.



.

.