Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clipboard Message
I have a procedure for copying data from one workbook to another and it
works perfectly except for one little niggle. At one point I use a copy and paste procedure and at the end of the whole transfer between workbooks, which are both open, one off the books is closed. At this point the standard message about data in the clipboard comes up with the options to save or not etc. This needs a user input which I really wanted to avoid . A message appears at the end of the transfer to confirm that all data has been transferred. Is there a way to shut off the clipboard message? I am conscious of Display Alerts but I am not sure if it applies to this situation and I do not want to turn off the final message. I value any guidance. Kind Regards Graham Haughs Turriff, Scotland |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clipboard Message
Graham
Try Application.CutCopyMode = False at the end of your code. Gord Dibben Excel MVP On Tue, 24 Aug 2004 21:37:02 +0100, "Graham Haughs" wrote: I have a procedure for copying data from one workbook to another and it works perfectly except for one little niggle. At one point I use a copy and paste procedure and at the end of the whole transfer between workbooks, which are both open, one off the books is closed. At this point the standard message about data in the clipboard comes up with the options to save or not etc. This needs a user input which I really wanted to avoid . A message appears at the end of the transfer to confirm that all data has been transferred. Is there a way to shut off the clipboard message? I am conscious of Display Alerts but I am not sure if it applies to this situation and I do not want to turn off the final message. I value any guidance. Kind Regards Graham Haughs Turriff, Scotland |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clipboard Message
Thanks Gord that has worked a treat.
Graham "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Graham Try Application.CutCopyMode = False at the end of your code. Gord Dibben Excel MVP On Tue, 24 Aug 2004 21:37:02 +0100, "Graham Haughs" wrote: I have a procedure for copying data from one workbook to another and it works perfectly except for one little niggle. At one point I use a copy and paste procedure and at the end of the whole transfer between workbooks, which are both open, one off the books is closed. At this point the standard message about data in the clipboard comes up with the options to save or not etc. This needs a user input which I really wanted to avoid . A message appears at the end of the transfer to confirm that all data has been transferred. Is there a way to shut off the clipboard message? I am conscious of Display Alerts but I am not sure if it applies to this situation and I do not want to turn off the final message. I value any guidance. Kind Regards Graham Haughs Turriff, Scotland |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Message: 'Cannot empty clipboard' | Excel Discussion (Misc queries) | |||
Message: Cannot empty clipboard | Excel Discussion (Misc queries) | |||
Error message: Cannot empty the clipboard. | Excel Discussion (Misc queries) | |||
Error Message: Cannot Empty the Clipboard | New Users to Excel | |||
By-passing clipboard message | Excel Programming |