ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   if the file is shared, do not execute macro (https://www.excelbanter.com/excel-programming/421883-if-file-shared-do-not-execute-macro.html)

nerohnze

if the file is shared, do not execute macro
 
I need some help about executing a macro if and only if the file is not shared.
I searched some codes like:
<If Workbooks("x.xls").Shared = True
But it didn't fit.
How can i adjust the code?
Thanks for help.

Dave Peterson

if the file is shared, do not execute macro
 
Look in VBA's help for: MultiUserEditing



nerohnze wrote:

I need some help about executing a macro if and only if the file is not shared.
I searched some codes like:
<If Workbooks("x.xls").Shared = True
But it didn't fit.
How can i adjust the code?
Thanks for help.


--

Dave Peterson


All times are GMT +1. The time now is 02:59 AM.

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