Alerts - how to cancel
There are usually ways to avoid any of these prompts. But each could have
disasterous results--imagine making tons of changes and closing. The workaround
would stop the alert and you'd lose your changes.
I surely wouldn't do it.
TT wrote:
I see. But if I close the file without clicking save, I won't be saving
anything anyway, correct? So I really don't need the alert since I'm not
saving any of the changes caused by volatile functions or events. Is my
thinking correct? So is there a way to get rid of the alert?
"Dave Peterson" wrote:
There are certain functions =now(), =today(), =indirect() (and others) that are
volatile. The update whether you make a change or not.
There could be worksheet/workbook/application events that could be firing that
change the workbook.
This is one of those warnings I'd try not to ignore.
TT wrote:
Everytime I open an excel file, flip through the different worksheets, didn't
make any change, and then exit, it always ask if I want to save changes.
Is there a way to cancel the alert? I want it so that if I close the file
without saving, that means I don't want to save anything I've done. I don't
need the alert. How do I take it out? Please help
--
Dave Peterson
--
Dave Peterson
|