A couple years ago I remember being able to tweak the UI (I don't
think I used TweakUI, but maybe) to let me right click on a
spreadsheet and choose to open it as read only. This is as opposed to
explicitly saving a file as read only or read only recommended.

I'm on a new machine and would like to be able to do so again?

A google for this in Usenet and web so far fruitless.

Anybody recall how to do this.

I remember that feature in the File|Open dialog. But I think it went away with
one of the newer versions of excel (xl2002 or maybe xl2k--it's not available
with xl2003 for sure).

Anyway, in xl2003, you can use file|open and select the file. But then use the
dropdown arrow on the Open button to see "open as readonly".

wrote:

A couple years ago I remember being able to tweak the UI (I don't
think I used TweakUI, but maybe) to let me right click on a
spreadsheet and choose to open it as read only. This is as opposed to
explicitly saving a file as read only or read only recommended.

I'm on a new machine and would like to be able to do so again?

A google for this in Usenet and web so far fruitless.

Anybody recall how to do this.

--

Dave Peterson