View Full Version : Solved: Disable "save changes" pop up when closing

09-06-2011, 01:46 AM
Hi all,

I have a workbook that has a workbook_open and workbook_beforeclose just to hide the ribbon, formula bar etc and then to show it again before closing.

Even if i'm not doing anything to the "save changes" pop up comes up and I imagine it's to do with the workbook_open/close macro. So my question is; is there a way to disable the pop up or a completly different way of getting round the problem?

Thanks in advance for all your comments/ help

09-06-2011, 02:05 AM
You could change its status

Activeworkbook.Saved = True

09-06-2011, 02:09 AM
Would I put this in the workbook_before close sub?

Edit: I put it at the end of the workbook_beforeclose and it worked exactly how I wanted it to. Thanks very much