View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
nerohnze nerohnze is offline
external usenet poster
 
Posts: 9
Default 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.