Notification of changes to excel files?
 

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)?

Notification of changes to excel files?
 

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.


--
Melisa Morris

www.awomantoldme.com



"Benno" wrote:

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)?

Notification of changes to excel files?
 

Also there's the problem that anything that requires VBA doesn't work if the
file is opened with macros disabled,
Regards,
Alan.
"Melisa Morris" wrote in message
...
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.


--
Melisa Morris

www.awomantoldme.com



"Benno" wrote:

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)?

Notification of changes to excel files?
 

Of course. I guess I assumed that would be understood but you are correct
Alan.
--
Melisa Morris

www.awomantoldme.com



"Alan" wrote:

Also there's the problem that anything that requires VBA doesn't work if the
file is opened with macros disabled,
Regards,
Alan.
"Melisa Morris" wrote in message
...
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.


--
Melisa Morris

www.awomantoldme.com



"Benno" wrote:

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)?