1

We are using .xlsm files stored on sharepoint which need to be updated regularly. I would like to inform all users about macro starts/ends running who has the file open. Would be great to simply add a MsgBox to the VBA code but as I tested it is visible only for that user who starts the macro. Is there any solution to inform other users?

Many Thanks, marci

Improve this question

1 Answer 1

Reset to default
0

Xls macros runs on local system and it is not connected to another users machine. You have to think of sending notifications to other users... may be send email or something..

Improve this answer
2
  • I see. It is an unfortunate situation in this case because it should be an on-time action - this is why I tried to use MsgBox instead of email. Anyway, I really apprichiate your help, many thanks for that
    – Marton
    Commented Jun 24, 2019 at 11:07
  • Yes...macro is not meant for that...please upvote and mark as answer if it was helpful.
    – Siddharth Vaghasia
    Commented Jun 24, 2019 at 11:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.