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!
Related:

1 response

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