How do I make a template in EXCEL
 

I just started working with EXCEL 2003. I have made a worksheet and now want
to lock only certain cells. How do I do this??

How do I make a template in EXCEL
 

Remember that "locking" a cell only "locks" the cell when the sheet is
protected (with or without a password).

With that in mind, all cells are 'locked' by default. To prove this,
open a new worksheet, select any cell and click FormatCells and select
the Protection tab. You will see the "Locked" option is checked.

Therefore, you actually need to 'unlock' cells you want users to have
access to, then protect the sheet (ToolsProtectionProtect Sheet).
You can choose to enter a password or just leave it blank. In the
"Allow all users..." section, uncheck "Select locked cells" and click
OK (re-enter password, if asked).

Now, users will only be able to select and change the 'unlocked'
cells.

HTH

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=525859