On close yes/no message box

Morning guys,

A bit of a confused question...

I want to run a procedure with before_close, the procedure is to bring up a yes/no message box. If the user selects yes, a sub procedure must run, save and then close, if no is selected, the book must just close.

Any help please?

Use a Public Boolean to determine if the procedure has been run.

Hi Roy,

If I select yes, I get a "Hello world", all well, however, when I select no, I get the same message, I then need to select no again, or I can select yes. Why is this?

Sorry I was rushing out to work this morning . Replace the close event code with this

Please Login or Register  to view this content.

Perfect! Thanks Roy, appreciate the help.

No problem. Don't forget to mark solved