Hello all!

I'm trying to adapt a worksheet change sub I've been using on my monthly reports that generates an email when the final cell is filled out.

In this other book, we have some sneaky peoples that keep unlocking the book and making changes and then saying they were there all along. (Senior management is more interested in catching who has been making the changes than creating an ironclad system.)

What worksheet property do I stick in here to set off the email? How do I prevent iteration after each change once the workbook has been initially unlocked?

Please Login or Register  to view this content.
Many thanks