![]() |
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