Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable message box during VBA code execution
Hi, I have a VBA Function which copies and pastes Ranges automatically. When executing the function, there are always message boxes like "There is a large amount of information on the clipboard. Do you want to be able to paste this information into another program later? To save it to the clipboard, click Yes. To delete it and free memory, click No" I always want to click Yes, as otherwise my code wouldnt work. Ho can I disable the displayment of these messages? Cheers Juergen -- juergenkemeter ------------------------------------------------------------------------ juergenkemeter's Profile: http://www.excelforum.com/member.php...o&userid=25248 View this thread: http://www.excelforum.com/showthread...hreadid=500417 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable message box during VBA code execution
Application.cutcopymode = false
should clear the clipboard. You could try: application.displayalerts=false 'your code application.displayalerts=true juergenkemeter wrote: Hi, I have a VBA Function which copies and pastes Ranges automatically. When executing the function, there are always message boxes like "There is a large amount of information on the clipboard. Do you want to be able to paste this information into another program later? To save it to the clipboard, click Yes. To delete it and free memory, click No" I always want to click Yes, as otherwise my code wouldnt work. Ho can I disable the displayment of these messages? Cheers Juergen -- juergenkemeter ------------------------------------------------------------------------ juergenkemeter's Profile: http://www.excelforum.com/member.php...o&userid=25248 View this thread: http://www.excelforum.com/showthread...hreadid=500417 -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable message box during VBA code execution
works fine, thx!! jk -- juergenkemeter ------------------------------------------------------------------------ juergenkemeter's Profile: http://www.excelforum.com/member.php...o&userid=25248 View this thread: http://www.excelforum.com/showthread...hreadid=500417 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code Execution Message | Excel Discussion (Misc queries) | |||
Disable VBA code execution when loading a workbook | Excel Discussion (Misc queries) | |||
disable and enable macro execution using VBA in another workbook? | Excel Programming | |||
Code Execution has been interrupted message | Excel Programming |