Auto Notify by email when the workbook is saved

[Bogdanmartin1988]

hello,

please help..
somebody know's a VBA code or something to announce you when somebody saves a common (shared) workbook?

Example: if somebody modify and after that saves the workbook, automatically an e-mail to be sent on "[email protected]"

and maybe it can be possible if in the email notification is specified who saves and what cells were modified.



Thank you verry much!

[Kramxel]

Please Login or Register  to view this content.

Add to the thisworkbook BeforeSave or BeforeClose event.

[Bogdanmartin1988]

hello and thank you very much for help but i still have an issue regarding this.
the code its working just when i hit run button "Run Sub" (F5) and how should i add "BeforeSave" ..maybe this is the reason that is not working.
Can you help me with that ?

Thank you!

[sktneer]

Add to the thisworkbook BeforeSave or BeforeClose event.

You missed the above instruction.

On VBA Editor --> Double click ThisWorkbook (from the project explorer on the left side) and place the following code into the opened code window.

Please Login or Register  to view this content.

[Bogdanmartin1988]

thank you very much for the answer
for this it is a big thing if it be possible to see wich cell's were modified or just the last cell