Forum Discussion
No Save Query on close
I have assembled a few workbooks that perform search functions or calculations that I allow others to use. I have the workbooks protected and I have locked all but the input cells. What I'm looking for is to not have Excel ask if you want to save the workbook when closing the file. It's protected so it can't be saved but I would like to disable the query so as not to confuse anyone. Is there a way to do this on Excel 365?
BTW: Since the input cells are blank, it is returning errors and zeros. Is there a way to fix that too? Thanks
1 Reply
See "How to suppress Save Changes" prompt when you close a workbook in Excel
VBA macros only work in the desktop version of Excel on Windows and Mac, and users will have to allow macros.
