Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
turn off pastespecial warnings
You could try :
Application.Displayalerts=FALSE Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone,SkipBlanks:=False, Transpose:=False Corey.... "Bruce" wrote in message ... When I do a paste special as below I get the following prompt; 'There is a large amount of information on the clipboard. Do you want to paste this information later. How can I auto answer No to this? Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:=False, Transpose:=False Regards, Bruce |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Warnings | Excel Discussion (Misc queries) | |||
Upcoming expiry date warnings that turn cell contents red | Excel Discussion (Misc queries) | |||
How do I turn off macro warnings? | Excel Programming | |||
Enable Warnings | Excel Programming | |||
Turn off warnings in Macro | Excel Worksheet Functions |