Hi All,
I have a shared excel sheet which is simultaneously used by couple of users placed in a network share. At certain instance of time I want to know who all are using the Workbook. You would say goto Tools-> Share Workbook. Instead I want to obtain the list of users via a macro and then want to send custom messages. Right now I want to give some updates specifically to the members who are using the sheet at certain point of time I have to see who are using the sheet from the Share Workbook menu and then IM them or Mail them. It becomes time consuming.
Is there a way to have a macro which can use the list of users and all the active workbooks in each of the users' desktop can receive a customized message I need to send them.
It would be of immense help if somebody can guide me through this