hi,

Is there a macro in sharing a workbook that doesn't display the message prompt to accept the changes made by other user? Currently I have a workbook that I would like it to be access using 2 computers simultaneously. Also, I would like the changes made on the shared workbook be displayed automatically without displaying any prompt nor messages regarding the changes made by some users. I would like to have the shared workbook be updated real time. Is this possible? Can anyone provide me a macro for it? Thanks a lot!

Cheers,

Stoey