Notification of changes to excel files?

B

Benno

Is there a way that i can set an excel file up to notify me (prefer email) if
when there has been changes made to it (or when it's been saved)?
 
M

Melisa Morris

I think this would have to be done using VBA. There is no setting that allows
this without coding. But you could set up coding to send you an email when
the spreadsheet is saved.

You can however set up modification tracking on a worksheet. Under Tools...
Track Changes... Highlight Changes, you would select the option to track
changes while editing. Then it allows you to set specific parameters for what
you want to track. The downside to this is that you have to go out and check
the spreadsheet to see if any changes were made.
 
A

Alan

Also there's the problem that anything that requires VBA doesn't work if the
file is opened with macros disabled,
Regards,
Alan.
 
M

Melisa Morris

Of course. I guess I assumed that would be understood but you are correct
Alan.
 
Top