Password protect cells but not the file

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

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

"so I've locked cells and password
protected the settings under Tools/Protection/Protect Sheet and Protect
Workbook. "
Unlock the cells you want the user to enter data and protect the
worksheet only,
there will be no problem then for people to enter data in the cells
that need info and the positive side is that when a sheet is protected,
and you have unlocked the cells, when a user presses the tab key the
next unlocked cell becomes active.
Dave

Damn you guys are good. I learned something. Thanks very much for the help...

Scott