You don't need to protect the workbook via file|saveAs|tools|options...

You want to protect the worksheet: Tools|protection|protect sheet

If you've already applied the password to open, then do the
file|saveas|tools|options... and remove that password.



sdubose99 wrote:
>
> Hi -- my worksheet is complete. I want to protect most cells, allow
> users to change a selected few, so I've locked cells and password
> protected the settings under Tools/Protection/Protect Sheet and Protect
> Workbook.
>
> What I do not want is for a password to be required to open the file.
> Protect cells from changes -- Yes. But require an initial password to
> open the file -- No.
>
> How to do that?
>
> thanks,
> Scott
>
> --
> sdubose99
> ------------------------------------------------------------------------
> sdubose99's Profile: http://www.excelforum.com/member.php...o&userid=27538
> View this thread: http://www.excelforum.com/showthread...hreadid=476046

--

Dave Peterson