VBA code to exit workbook with a Pop-up message

[ravi.talalur]

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:

Private Sub WorkBook_open()
      MsgBox "welcome to my file"
End Sub

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


Regards,
RT