![]() |
Notice that there was a change
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 |
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 |
Notice that there was a change
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 -- Message posted via http://www.officekb.com |
All times are GMT +1. The time now is 10:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com