I would like the MsgBox to appear before closing Excel file.
I have this code:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
MsgBox Prompt:="CONTENT", Title:="title"
End Sub

but I want a link to www site and to e-mail address in CONTENT
Could somebody tell me how to do this?

thanks