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

[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

 

[Ivan Raiminius]

Hi Puakeni,

see help for workbook_beforesave and workbook_beforeclose events.

Let me know if you need more details,

Regards,
Ivan

 

[Tom Ogilvy]

Believe Ivan is indicating you should use the beforeclose event to set

Thisworkbook.Saved = True

to see if it suppresses the message.

If your not familiar with events, you should see Chip Pearson's page for an
overview
http://www.cpearson.com/excel/events.htm

 

[puakeni1]

Thanks for the replies folks. I found something that works.

Have a great weekend!
puakeni