Popup window when the Excel file is saved/updated

Closed
Atmandu
Posts
2
Registration date
Saturday July 16, 2016
Status
Member
Last seen
July 23, 2016
- Jul 16, 2016 at 10:34 AM
Atmandu
Posts
2
Registration date
Saturday July 16, 2016
Status
Member
Last seen
July 23, 2016
- Jul 23, 2016 at 03:59 PM
Hello,

I have an Excel file which is used by multiple users (saved on the network drive). They can only open the file as read-only.
I'm looking for a macro that will create a popup window (at the computers which have the file opened - read only) whenever I save the file. So that they know the file has changed.

I have searched on google for a while and found this thread:
https://ccm.net/forum/affich-107579-auto-notify-or-mail-when-excel-sheet-updated
The code mentioned in one of the answers lets me send an email. I've tried to adapt the code but so far no success.

Can anyone help me with this?
Thanks in advance!

1 reply

Atmandu
Posts
2
Registration date
Saturday July 16, 2016
Status
Member
Last seen
July 23, 2016

Jul 23, 2016 at 03:59 PM
Nobody with an idea or similar macro?
0