open workbook for sharing
 

Hi,

I need to open a workbook for sharing.

I am using this code to open the workbook:

Set wb = Workbooks.Open(ActiveWorkbook.Path & "\Ongoing")

what do I need to add to the end of it to make sure it is shared?

Thanks,

Albert

open workbook for sharing
 

Shared is an attribute of the workbook so you do not need to specify
anything. You just need to save the book as a shared book. Note that sharing
is a type of protection and that Macro's and shared workbooks don't get
along. Some things work. Lots of things don't. There will be lots of trial
and error to get the code to work and you will not be able to get a lot of
help from this forum becuase most of the folks around here avoid shared
workbooks as they are more trouble than they are worth in most circumsatances.
--
HTH...

Jim Thomlinson


"Albert Browne" wrote:

Hi,

I need to open a workbook for sharing.

I am using this code to open the workbook:

Set wb = Workbooks.Open(ActiveWorkbook.Path & "\Ongoing")

what do I need to add to the end of it to make sure it is shared?

Thanks,

Albert