Send Email When Excel File Gets Unprotected (1 Viewer)

[BowDan]

Hello Everyone,

Is there any way to send an email by vb script when Excel file gets unprotected? If there is, can you provide me the code as well? I need this for one of my review courses.

Thanks in advance for your suggestions.

Best Regards.

 

[Gasman]

Not when it actually happens, I would have thought? Always happy to be proved wrong though.
I would expect you would need to run some code on a timer to check the state of the file?

In VBA you could have some code in the workbook.
A quick Google reveals

test if excel file is umprotected vba - Google Search

Another Google or a quick search here would also give code on how to send an email from VBA.