Don't make changes to the workbook when it's open.
Don't have macros run that make changes to the workbook.
Don't use volatile functions that recalc (and tell excel that the workbook has
been changed). Some of these functions are =now(), =rand(), =date(),
Don't make changes to the workbook when it's open.
Don't have macros run that make changes to the workbook.
Don't use volatile functions that recalc (and tell excel that the workbook has
been changed). Some of these functions are =now(), =rand(), =date(),
Dave, I suspect you answered the question that the OP meant to ask ... but
the question as asked says how can they make sure that they *are* asked if
they want to save changes.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.