Solved: Disable "save changes" pop up when closing

[owen_1987]

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

[Bob Phillips]

You could change its status

[vba]
Activeworkbook.Saved = True
[/vba]

[owen_1987]

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