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.
I hasten to add that neither do I, as I have never seen that in any
version of XL from 5 to 2003 SP3.
Ask a Question
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.