Trending Global Macro Discussions

Follow

Ask the Community


Ask any professional question and get answers from other specialists.

Stream language
Pablo Dimaunahan's image
Question added by Pablo Dimaunahan AV and ELV CAD Draftsman Site Technology LTD. Co.
9 years ago

Excel macro email notification‎

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

Answers:
2
Followers:
Views:
311
Vote Count:
0
Answer should contain a minimum of 25 characters.
FITAH MOHAMED's image  
Answer added by  FITAH MOHAMED, Financial Manager, FUEL AND ENERGY CO for transportion petroleum materials
9 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

Firas Shahadi's image  
Answer added by  Firas Shahadi, Human Resources Director, SAUDI UNION
7 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