When i exit workbook when running vba, I dont want any pop up to come up. Close workbook without saving it. Please help.

[pedie]

Hi,

Wb is workbook here.
I have coded in the end of my code with the below line
but it still ask there is many things copied, do you want to save data for later use?
Though it did not ask do you want to save this copy?
can vba make this pop up go away?

wb.Close savechanges:=False

 

[VoG]

If you mean the message about a large amount of data in the clipboard try

Application.CutCopyMode = False
wb.Close savechanges:=False

 

[pedie]

That worked...thanks alot VoG!

Have a great weekend!