Tools|Options, Security tab
Here, you can set password to open it. You can also set a password to modify
it (which will allow the user to open the file, and it will pop up a password
box to modify, they can just select read only and still open, but not be able
to modify). Check the selections, and I am sure you can figure it out.

Note: Excel security is really not that secure though.
--
John C


"Barb W" wrote:

Is there a way to open a file in read-only mode even if the file is not open
by another user? I sometimes want a file open for reference, but don't want
to prevent other people from opening and editing.