Shared Workbooks - conflicts

  • Thread starter Thread starter Rabangus
  • Start date Start date
R

Rabangus

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

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

Excel macro code for copying data to a cell reference which is set byvalues in two separate cells in 3
Sharing workbooks limitations - Merged Cells 12
Sharing workbook removes cell protection 1
Shared Workbook Crash 0
Search/Compare VBA Help 3
Another Question about Save As Dialog box 3
Track Changes without sharing a workbook? 2
Last Modified By in a cell by user 3

Back
Top