VBA code to exit workbook with a Pop-up message

**ravi.talalur** · 05-13-2013, 10:24 AM

Hello,
I wanted to have a VBA code to get a pop-up message when workbook:
-Opened
-Before closing

I have one VBA code written to open and it is working perfect! as below:

Please Login or Register  to view this content.

but for the same workbook i could not get the correct exit VBA code.
Your's assistance is highly appreciated.

Regards,
RT

**nathansav** · 05-13-2013, 12:57 PM

Private Sub Workbook_BeforeClose(Cancel As Boolean)

**ravi.talalur** · 05-13-2013, 02:03 PM

Thanks Nathan.

Infact the exit code also i know as below:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
MsgBox "Bye for now"
End Sub

I have pop welcome message created through -} Alt + F11 -} This workbook -} paste pop-up message as "welcome to my file" as stated in my original post.
Now i am trying to have exit message as well pasted as above to the same XL file and i dont know where to have the above VBA code executed?
[i.e. Should the exit VBA code be present in "this workbook" in project explorer or any other?, i tried having welcome message and exit message in "This workbook" but throws up an error]