Make sure the MyNewWorkbook.Saved = True is the last line of the routine. But, if your file contains any volatile functions like TODAY, NOW or INDIRECT, there is nothing you can do to prevent this message.