| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Paste and Paste Special command are not enabled in Excel | Excel Worksheet Functions | |||
| paste command not work in 'comment' | Excel Discussion (Misc queries) | |||
| How do I add a command button on a worksheet to "paste" from the . | Excel Worksheet Functions | |||
| How do I add a command button on a worksheet to "paste" from the . | Excel Worksheet Functions | |||
| copy & paste command button | Excel Programming | |||
Linear Mode
