Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to respond to clipboard prompt?
Does anyone have a snipit of code that will respond to the
clipboard prompt... "There is a large amount of information on the clipboard. Do you want to ..." Thanks, Regards, Gary |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to respond to clipboard prompt?
"gary" wrote in message
... Does anyone have a snipit of code that will respond to the clipboard prompt... "There is a large amount of information on the clipboard. Do you want to ..." Hi Gary, Application.CutCopyMode = False will prevent this message from being displayed. Just make sure you're done with whatever is on the clipboard before you use it, because it will clear the clipboard. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to respond to clipboard prompt?
Rob,
Thanks. I should have explained more throroughly. I do want to keep the info in the clipboard. I am consolidating information from a number of workbooks into a single workbook. I do not want the user to have to respond "yes" to every prompt. Based on your suggestion, I tried Application.CutCopyMode = xlCopy but the macro failed on the paste... any suggestion? Thanks, regards, Gary -----Original Message----- "gary" wrote in message ... Does anyone have a snipit of code that will respond to the clipboard prompt... "There is a large amount of information on the clipboard. Do you want to ..." Hi Gary, Application.CutCopyMode = False will prevent this message from being displayed. Just make sure you're done with whatever is on the clipboard before you use it, because it will clear the clipboard. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to respond to clipboard prompt?
Gary, you could try
Application.DisplayAlerts = False 'Your Code that is making the prompt come up Application.DisplayAlerts = True -- Paul B Always backup your data before trying something new Using Excel 2000 & 97 Please post any response to the newsgroups so others can benefit from it ** remove news from my email address to reply by email ** "gary" wrote in message ... Does anyone have a snipit of code that will respond to the clipboard prompt... "There is a large amount of information on the clipboard. Do you want to ..." Thanks, Regards, Gary |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to respond to clipboard prompt?
Hi Gary,
If you want to keep the clipboard but disable the message, then Paul's suggestion on DisplayAlerts is the way to go. Just be sure that DisplayAlerts is set to True before your program finishes. This is a persistent setting that will suppress all Excel warnings even after your code has ended. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * "gary" wrote in message ... Rob, Thanks. I should have explained more throroughly. I do want to keep the info in the clipboard. I am consolidating information from a number of workbooks into a single workbook. I do not want the user to have to respond "yes" to every prompt. Based on your suggestion, I tried Application.CutCopyMode = xlCopy but the macro failed on the paste... any suggestion? Thanks, regards, Gary -----Original Message----- "gary" wrote in message ... Does anyone have a snipit of code that will respond to the clipboard prompt... "There is a large amount of information on the clipboard. Do you want to ..." Hi Gary, Application.CutCopyMode = False will prevent this message from being displayed. Just make sure you're done with whatever is on the clipboard before you use it, because it will clear the clipboard. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Override prompt for Office Clipboard | Excel Discussion (Misc queries) | |||
Macro prompt | Excel Discussion (Misc queries) | |||
Macro Prompt | Excel Discussion (Misc queries) | |||
How do I respond to a Solver Results Dialog Box from a macro? | Excel Discussion (Misc queries) | |||
Need to turn off prompt about putting on clipboard or not... | Excel Discussion (Misc queries) |