Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alerts
Hi..
I have a macro that opens one sheet copies a lot of data then pastes it into another but an alert comes up asking me if I want to save whats on the clipbard that halts the code...how can I get rid of this clipbard message.. Cheer Jimbo |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alerts
Jimbo wrote:
Hi... I have a macro that opens one sheet copies a lot of data then pastes it into another but an alert comes up asking me if I want to save whats on the clipbard that halts the code...how can I get rid of this clipbard message... You could try using "Application.DisplayAlerts = False" before your code and then "Application.DisplayAlerts = True" after the code is executed. Regards, -- Beto Reply: Erase between the dot (inclusive) and the @. Responder: Borra la frase obvia y el punto previo. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alerts
another approach is to do
Application.CutCopyMode = False after the paste. This will clear the clipboard. -- Regards, Tom Ogilvy "Jimbo" wrote in message ... Hi... I have a macro that opens one sheet copies a lot of data then pastes it into another but an alert comes up asking me if I want to save whats on the clipbard that halts the code...how can I get rid of this clipbard message... Cheers Jimbo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Alerts.... | Excel Discussion (Misc queries) | |||
Alerts | Excel Discussion (Misc queries) | |||
Alerts | Excel Discussion (Misc queries) | |||
alerts | Excel Worksheet Functions | |||
Alerts? | New Users to Excel |