Shared Workbooks - automatically resolve conficts
 

All,

As you are probably aware, when two users of a shared workbook update
the same cell, on saving they are given the choice of accepting their
changes or those of the other user.

Is there any way using VBA to automatically accept the changes of the
current user -for certain ranges-, so that user won't even see the
dialog box asking them if they want to accept their changes or the
other user's?

Cheers
Rowan


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