Excel 2010: Macro that will Inform others of any updates Done
Posted on 2013-01-31
I have a workbook that consists of 4 worksheets. I'm curious if anyone has a macro that will notify others of any updates that are done on any worksheets in a workbook. Just a quick notification email saying "An entry as added to such and such on such and such date"
What would be perfect is after an entry as made to the worksheet, you could then press a control button to invoke the macro. A window would then pop up asking "How many entries where made to worksheet (type in name of worksheet)?" You'd then enter that number and click OK. It would then send an email to notifying others that an entry was made with the spiel above:
""An entry as added to <worksheet name> on such on such date"
Much thanks for any help or suggestions on this!