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
2 Replies
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.
Thanks. I was hoping to avoid macros. If the user has to allow macros every time they open the workbook, it's as much a nuisance as having to tell Excel not to save the workbook every time. Seems like Excel would have a simple solution to Not Save a protected workbook.
