Share/Unshare Workbook

[GGIO]

Hi all,

I'm looking for a code that will share/unshare a workbook.

Thanks in advance,

 

[Jonmo1]

Sorry, that code does not exist.

It's one of several things that just cannot be done to a shared workbook with Code.
And it's why many people prefer to use Access instead of Excel for Multiple User Data Entry.

 

[Domski]

There seems to be a solution here but never tried it:

http://www.mrexcel.com/forum/showthread.php?t=258787

Hope it helps,

Dom

 

[GGIO]

Thanks for the help!

 

[ipisors]

I am not sure why JONMO posted that.

It is quite easy - to unshare workbook, put:

ThisWorkbook.ExclusiveAccess

to re-share it, use

ThisWorkbook.SaveAs ThisWorkbook.FullName, xlaccess:=xlshared

 

[Jonmo1]

I am not sure why JONMO posted that.

It is quite easy - to unshare workbook, put:

ThisWorkbook.ExclusiveAccess

to re-share it, use

ThisWorkbook.SaveAs ThisWorkbook.FullName, xlaccess:=xlshared

We all put up howlers every now and then...observe my Avatar....lol
I was just glad that someone gave the correct answer.

 

[ipisors]

true dat'

didn't mean to be rude, was just surprised since I am usually always the one asking the questions (not able to help people much) and I was like hey - could it be??

 

[Jonmo1]

Not that it matters, but that post was 2 years prior to being voted in as an MVP.
So I was still in the learning stages...

 

[Domski]

So I was still in the learning stages...

Still are