Open a file as read only one time

[act2106]

I am interested in learning how to open a file as read only sometimes and not read only other times. I don't want to set a specific file to always open read only, but I want to have the option of opening any of hundreds of files on the network read only. I would like this to just happen on my computer, not anyone else's on the network. I am using Excel 2007.

Using Windows 7, if I do shift and right-click on a file from Windows Explorer, one of the options is Open as Read-Only. This seems like a perfect solution, but when I select this, the file opens with read-write access.

Does anyone know of a way to accomplish this?

 

[sijpie]

If you go through normal Excel File Open, and select your file, then next to the Open button, there is a little arrow, click on it and you get - Open Read Only as an option.

https://lh6.googleusercontent.com/-...o8/mRWjQoeS84c/w571-h580-p-o/OpenReadOnly.gif

 

[act2106]

Thanks, sijpie. It works! I usually open files from Windows Explorer so I'll have to get used to opening them from Excel instead.