Activate a dialogue box

[Brendan63]

Hi,

I have just finished an excel macro that involves copying a sheet and pasting it into another. I had the macro then close the workbook sheet but an excel message
"there is a large amount of information on the clipboard...."
prevents the macro from finishing,
Clicking "no" allows it to finish but is there a way for the macro to do it?

Brendan

 

[Kenneth Hobson]

Welcome to the forum!

Application.DisplayAlerts = False
'Do your thing
Aplication.DisplayAlerts = True

 

[Brendan63]

Great thanks, works like a dream