View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default Notice that there was a change

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:

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

--
Message posted via http://www.officekb.com