View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Melisa Morris Melisa Morris is offline
external usenet poster
 
Posts: 4
Default 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)?