MsgBox to list users in shared workbook

Hi all,

I am trying to figure out if it is possible to populate a message box on open, that will list all current users of a shared workbook.

I have tried playing with some code as a Workbook Open event - but have had no joy.

Could it be done with Workbook.Activeuser?

Thanks

Rob

A previous reply from Bill Manville http://tinyurl.com/qa7r2

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"systemx" <[email protected]> wrote in
message news:[email protected]...
>
> Hi all,
>
> I am trying to figure out if it is possible to populate a message box
> on open, that will list all current users of a shared workbook.
>
> I have tried playing with some code as a Workbook Open event - but have
> had no joy.
>
> Could it be done with Workbook.Activeuser?
>
> Thanks
>
> Rob
>
>
> --
> systemx
> ------------------------------------------------------------------------
> systemx's Profile:
http://www.excelforum.com/member.php...o&userid=29254
> View this thread: http://www.excelforum.com/showthread...hreadid=520577
>