VBA Email notification

[galmond1010]

Is it possible to have an email notification when one of my files is open by another user? I have used MsgBox and With Outmail code before but it was when someone ran my macro. I wasn't sure if it can be done with my file is opened. Thank you in advance.

 

[Kamolga]

There is an open workbook event: In VBA, 2x click "ThisWorkbook" under the sheets name and paste

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]Private Sub Workbook_Open()
 With ActiveSheet.MailEnvelope
        .Introduction = "File 123 was opened"
        .Item.To = "myemail@adress.com
        .Item.Subject = "I opened your file"
    'Chose display or send
        '.Item.display
        .Item.send
    End With
End Sub[/FONT]

 

[Joe4]

Just note that they can get around this by disabling Macros/VBA when opening the workbook.

What I have seen some people do is hide and protect the sheet so that no data is shown, by default, and to have code to unhide it in the same Workbook_Open event procedure code. That way, if they do open it with disabling VBA, it is essentially worthless to them, as they will not see anything.

 

[galmond1010]

Thank you very much.