open workbook for sharing

  • Thread starter Thread starter Albert Browne
  • Start date Start date
A

Albert Browne

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with function 2
Open WorkBook & Run Macro 3
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Run subroutines in other workbooks? 4
Open Workbook Assignment 2
closing another file by code causes failure to run workbook activate event 2
All Workbook Saved except This Workbook 3
help with VBA program to import and add formatted files to one file 0

Back
Top