shared file !
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 -
|