send Email to specific person if spread sheet is updated

i had made a spread sheet on share folder, so the manager want to see the file when updated by users

so if user update the workbook saved and closed manager got email through excel tell him that the file was updated without attaching the workbook to him
just a notification so he can check the file on shared folder
notification title "File Cinvestigation was updated"
suppose that manager email is "[email protected]"

thanks

i am not familiar with vba
so what i need is press alt+f11
then where i go select the sheet?
insert module then paste
Option Explicit

Sub saveStatus()

If ActiveWorkbook.Saved = False Then
Mail_workbook_Outlook
Else
'Nothing goes here. Leave blank
End If

End Sub


Sub Mail_workbook_Outlook()


Dim OutApp As Object
Dim OutMail As Object
Dim sndEmail As String
Dim ccEmail As String
Dim bccEmail As String

Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)

On Error Resume Next

With OutMail
.To = "[email protected]"
.CC = ""
.BCC = ""
.Subject = "File Cinvestigation was updated"
.Body = "File Cinvestigation was updated"
.Send
End With

On Error GoTo 0

Set OutMail = Nothing
Set OutApp = Nothing

End Sub
and close?

can yo explain briefly

sorry for that

.
See attached file above.

thanks for your help
so what i understand
on developer tab > visual basic
then on right vba project vba right click on microsoft excel object

adding module then paste the code?

note i am using outlook

.
To create a Regular module (if your project doesn't already have one), click on INSERT in the menu bar,
then on MODULE.

On the right side window, you will paste the larger macro as seen in my first post.


Then, looking back at the smaller pane on the upper right, you should see a list of the worksheets in your workbook as well as a
module named ThisWorkbook. Double click the "ThisWorkbook". You should see a blank window pane on the right that will initially
look just like the REGULAR MODULE after you clicked on INSERT.

If the ThisWorkbook module hasn't already been utilized it will appear blank. If there is code already there don't worry.

You will paste the smaller macro into the ThisWorkbook module.

Save the workbook.

It should function as desired .. as the sample workbook I attached above.

.
Thanks for the Rep !

Glad to help.