MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by steve on December 28, 2001 12:13 PM

what if you want to turn off the display alerts but want an option other than the default to be saved? i.e. you save some worksheets using savecopyas but dont want to modify the original worksheet?

Posted by Bariloche on December 28, 2001 5:28 PM


Just reset the "Saved" property to True, e.g.:

Workbooks("Book3").Saved = True

This will fool Excel into thinking that the workbook has already been saved, eventhough it hasn't. Try it with a new workbook (like "Book3") and see what happens. After setting the Saved property Excel will let you close Book3 without prompting you to save it, but if you go and look for it, it won't be any where ('cuz it wasn't really saved.)