Thanks a lot Jim


On Jun 17, 5:19*pm, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-
This-.com wrote:
if ActiveWorkbook.MultiUserEditing then
*msgbox "... * "

--
HTH...

Jim Thomlinson



"fi.or.jp.de" wrote:
Hi All,

Is there any vba code to know whether the active workbook is shared
or
not ?

like this .....
* * * *if activeworkbook is shared then
* * * * * * *msgbox "you file is shared, remove share"
* * * else
* * * * * "my code goes here....."
* * * end if

thanks in advance.- Hide quoted text -

- Show quoted text -