ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Closing the save changes box (https://www.excelbanter.com/excel-programming/287417-re-closing-save-changes-box.html)

John Tjia

Closing the save changes box
 
This closes the workbook and discards any changes

Thisworkbook.close saveChanges:=False


CrazySultana wrote in message ...
Hello :)

I have written a macro that opens up a file (1), changes a few things and copies the data to an already open file.
The macro then proceeds to close file 1, and the save changes dialogue box pops up. How can I make my code automatically select no or prevent that box from popping up?

Thanks for any help



All times are GMT +1. The time now is 09:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com