Refresh a Currently open Excel Sheet?

[Bundy]

Hi Guys,

Here's scenario.

Person A Opens a document & updates/Saves it all day.

Person B,C,D Open the same document as Read Only.

Is there any VBA Code that can be used to refresh the read only version of B,C,D as maybe a button added to the sheet? (or any other options to use?)

 

[Sahak]

Thank you Erik very much.

 

[erik.van.geit]

You're welcome!
Just saw your signature:
I Envy The Person Who Knows Excel All The Way.
You would envy a person which does not exist

Have a nice day!
Erik