PDA

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



owen_1987
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

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


Activeworkbook.Saved = True

owen_1987
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