I need to set up a worksheet that allows people to view it, but requires a password to modify it. The last time I did this, I clicked the Microsoft Office Button > Save As > Tools > General Options, and added the password.



When I tried that today, there was no "Tools" option on the Save As dialog. When you scroll down, there's one more option not visible in this image, but it is for saving as other formats, not "Tools." I attached a screen shot of the dialog - I'm not crazy. It isn't there anymore.

I went to online help, which instructs me to do it precisely the way I remember always doing it in the past. The only thing I can think of is that we had an automatic Office 2007 update that removed the functionality.

Now the only thing I am left with was Encryption, which doesn't allow you to view the spreadsheet unless you enter a password. This is NOT what I need. I also don't want to protect the cells and unlock them every time I open the spreadsheet because it leaves too much opportunity for me to forget to lock them when I close.

...Unless Microsoft just moved password protection somewhere else, and didn't update their online help. If so, how do I do this now?

Thanks!

Attached Images

saveas.JPG (27.1 KB, 13 views)