Prevent anyone "Saving" a shared workbook

This is a funny one, not sure if it can be done.

Firstly, I have a shared workbook used by my colleagues. The file is only used for reference, not to be edited by my colleagues, only I can edit it from the original file (which can only be done if all the shared books are closed).

Now, unfortunately some of my colleagues go and search for an item then press "Save", doing this causes the workbook to save on the item they had been searching for.

Is there a way to prevent this from happening so that each time the workbook is opened, it always goes to a default layout?

(Now, before any one mentions that I should not share the file and make it "Read Only", unfortunately the staff I work with are much much older and not technological, so when they see the dialog box stating it is read only, they assume something is wrong and exit the workbook, even though I have mentioned time and again that they only need to click on 'Read Only'. A shared workbook does not come up with this error message.)

Thanks

Hi

Since it's only for reference, how about you saving file as a PDF for others to use? Otherwise your network administrator should be able to give users Read access only.

Regards
Alan

Thanks A.Clubb for the reply, I should have mentioned that there is a search formula for a large database in the file, so a PDF file wouldn't work.

Excelko, I'm not able to test the password out yet but it looks like something very useful I could use and would resolve my issue, thanks so much!