Notice that there was a change

[Ana via OfficeKB.com]

Hello!
I have a folder with 20 excel files in it. Some other users can open them and
change it. Is there any easy way for me to get to know that there was a
change? I put the password, but that is just not enough. So, if someone open
any of those 20 excels, and change something I want to get some kind of
notice (excel become blue, or I get mail or anything at all....).
Please help!
Ana

 

[Stefi]

One possible way is to insert BeforeSave event macros in all workbooks which
send an email to you.

See http://www.rondebruin.nl/mail/folder3/smallmessage.htm on sending email!

Regards,
Stefi

„Ana via OfficeKB.com†ezt írta:

 

[abolen via OfficeKB.com]

Dear Stefi ,
you were right, I really don't use MS Outlook, but Outlook Express, so could
you send mi the link to that page you were refering to, please? I like the
code you've sent me very much and I'm eager to try it. Thanks in advance!
Ana