Forum Discussion
dls5u
Jun 06, 2025Copper Contributor
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 ...
HansVogelaar
Jun 06, 2025MVP
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.
dls5u
Jun 12, 2025Copper Contributor
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.