I am trying to figure out how to make one of my sheets in my workbook to be automatically emailed to me and cc'd to others when my employees finish entering data in the sheet. I will then always know when someone has updated the sheet. I have attached the workbook. The Sheet is named "Communication Log". I currently have VBA Code applied for it to automatically lock the the cells after they are typed in. The password to unlock the sheet is "Password", (Capital "P"). I would like to be able to enter the email addresses that the sheet will be sent to, somewhere on the sheet, maybe directly to the right at the top. My email address is: [email protected]. for test purposes. Any help would be greatly appreciated.
Thank you
Bookmarks