Don't make it a Shared Workbook.

tstb wrote:

How do I make my workbook read only to another user whilst I am making
changes. Why is the other user not getting a read only prompt, they are also
making changes causing save problems. I have not ticked the allow changes
by more than one user box in the tools menu.