Trending Global Macro Discussions

Excel macro email notification‎

Macro that send email notification if the exel file(s) is/are modified‎

Answers:

2

Followers:

2

Views:

311

Vote Count:

0

 

Answer added by  FITAH MOHAMED, Financial Manager, FUEL AND ENERGY CO for transportion petroleum materials
8 years ago

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, _ Cancel As Boolean) Dim answer As String answer = MsgBox("This is where you put the text ... See More

 

Answer added by  Firas Shahadi , Training And Development Director, Muhayal Assir National Hospital
6 years ago

sending email is easy. but to send an email every time the sheet changed, you need to think about it.   to send the work book check this web site here