| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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)? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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)? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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)? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel files suddenly unreadable | Excel Discussion (Misc queries) | |||
| HELP! Transfering files to Excel | Excel Worksheet Functions | |||
| How do I get cell data in multiple Excel files into one summary fi | Excel Worksheet Functions | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Excel Files Acting Weird | Excel Discussion (Misc queries) | |||
Linear Mode
