protect sheet question

[ituser2008]

I have added the password on the excel spreadsheet to protect the formula. How can I just protect section of the file?? I want to allow user to insert row or column into the file. thanks

 

[kjv1611]

So, you only want to protect one cell out of the sheet?

To do that:
[OL]
[LI]Remove the password.[/LI]
[LI]Select all cells in a single worksheet.[/LI]
[LI]Select the "Format" menu.[/LI]
[LI]Select "Cells"[/LI]
[LI]Select "Proection" tab[/LI]
[LI]Uncheck "Locked"[/LI]
[LI]Click "OK"[/LI]
[LI]Select the cell you want to protect[/LI]
[LI]Right-click on that cell, and choose "Format Cells"[/LI]
[LI]Select "Protection" tab[/LI]
[LI]Check the "Locked" checkbox.[/LI]
[LI]Now set a password to the worksheet, and see if that works for you.[/LI]
[/OL]

--

"If to err is human, then I must be some kind of human!" -Me

 

[ituser2008]

I have tried this in office 2000 and 2003, it appeared it only work with 2003. but most users have 2000, how do i fix this??

 

[SkipVought]

I believe that addtional Sheet Protection features were added in the 2003 version. Check

http://www.microsoft.com

to compare features in 2003 with previous versions.

Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}