Auto Email when ANY changes made to excel workbook

denerobt

New Member
Joined
May 15, 2014
Messages
1
Hi everyone,

I'm trying to get the code to run as a macro to auto email a few people whenever any changes are made to a workbook that deals with peoples training.

So, each person in our team gets a copy of the training database. Whenever they make a change and update it, an email gets automatically sent out to about 6 people saying what changes were made. we can then make amendments to the MASTER copy of that workbook.

obviously, ideally we'd just have 1 workbook which peole could access on a shared drive and then an email notification gets sent out upon a change.

Hope you clever people can point me in the right direction.

Many thanks

Rob sutherland
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Watch MrExcel Video

Forum statistics

Threads
1,095,926
Messages
5,447,329
Members
405,447
Latest member
WPY

This Week's Hot Topics

Top