Using VBA to set a workbook's property to shared.

  • Thread starter Thread starter mika.
  • Start date Start date
M

mika.

Can someone tell me how I can set a workbook's property to
shared using VBA? I know that
ThisWorkbook.MultiUserEditing
checks to see if it is shared, but how would one set the
workbook to shared?

Thanks for the help.
 
I started a new workbook and recorded a macro as I swapped back to a different
workbook and shared that.

This is what got recorded:

Option Explicit
Sub Macro4()
ActiveWindow.ActivateNext
ActiveWorkbook.KeepChangeHistory = True
ActiveWorkbook.SaveAs Filename:="C:\My Documents\excel\book2.xls", _
AccessMode:=xlShared
End Sub

I bet it's enough to get started.
 
You must log in or register to reply here.

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

Sharing workbooks limitations - Merged Cells 12
Excel VBA 0
shared workbook - shared workbook options grayed out 0
sharing workbook 2
Sharing VBA procedures; alternative to personal.xls? 5
Microsoft 2007 Excel - Share Workbook Error 2
How to Activate "Show all" in a Protected Shared Workbook 1
Locking cells in a shared workbook 2

Back
Top