ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   shared excel workbook (https://www.excelbanter.com/excel-worksheet-functions/234135-shared-excel-workbook.html)

fi.or.jp.de

shared excel workbook
 
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.


All times are GMT +1. The time now is 08:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com