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
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