ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Notice that there was a change (https://www.excelbanter.com/excel-discussion-misc-queries/238436-notice-there-change.html)

Ana via OfficeKB.com

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


Stefi

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



abolen via 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