shared file !

[fi.or.jp.de]

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.

 

[Jim Thomlinson]

if ActiveWorkbook.MultiUserEditing then
msgbox "... "

 

[fi.or.jp.de]

Thanks a lot Jim

if ActiveWorkbook.MultiUserEditing then
 msgbox "...   "

--
HTH...

Jim Thomlinson








- Show quoted text -