Alerts

[Guest]

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

 

[Beto]

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,

 

[Tom Ogilvy]

another approach is to do

Application.CutCopyMode = False
after the paste. This will clear the clipboard.

--
Regards,
Tom Ogilvy

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...