When a user amends the same cell as another using on a shared workbook,
upon saving a dialog box pops up detaling the cells that both users
have amended.

Is there any way in VBA to return those cells? I'm hoping to deal with
the cells without the user knwoling about it.

Cheers
Rowan


--
Rabangus
------------------------------------------------------------------------
Rabangus's Profile: http://www.excelforum.com/member.php...o&userid=28905
View this thread: http://www.excelforum.com/showthread...hreadid=530979

I certainly doubt it. It is done in response to the save. To the best of my
knowledge, access to the conflict information is not exposed in the object
model.

That said, I believe there is a hidden sheet named History that you might
want to examine. I will have to admit that I don't deal with shared
workbooks, so my answer is based more on my understanding of the object model
than having ever tried to deal with the problem.

--
Regards,
Tom Ogilvy


"Rabangus" wrote:


When a user amends the same cell as another using on a shared workbook,
upon saving a dialog box pops up detaling the cells that both users
have amended.

Is there any way in VBA to return those cells? I'm hoping to deal with
the cells without the user knwoling about it.

Cheers
Rowan


--
Rabangus
------------------------------------------------------------------------
Rabangus's Profile: http://www.excelforum.com/member.php...o&userid=28905
View this thread: http://www.excelforum.com/showthread...hreadid=530979