Can the Save Changes prompt be bypassed when using a volatile function?

  • Thread starter Thread starter puakeni1
  • Start date Start date
P

puakeni1

I've researched the forums and it looks like the "Do you want to save
changes" prompt will always appear when a volatile function is used (in
my case I'm using several). But I haven't seen a solution to bypass
this prompt (as removing the volatile functions is not an option for
me). The file is protected and users can only access it as read only.
The answer to the prompt will always be "no." Is there a code that
will bypass this message?

TIA for assistance!

puakeni
 
Hi Puakeni,

see help for workbook_beforesave and workbook_beforeclose events.

Let me know if you need more details,

Regards,
Ivan
 
Thanks for the replies folks. I found something that works.

Have a great weekend!
puakeni
 
Back
Top