View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Jed Jed is offline
external usenet poster
 
Posts: 10
Default Protecting selected cells in a worksheet

Thanks, you led me to the right way to do it!. you are smart!

"Jim Thomlinson" wrote:

There are 2 steps in protecting cells. One is locking the cells and the other
is protecting the worksheet...

1. Locking the cells - By default every cell in a spreadsheet is locked. You
need to unlock those cells that you want the end users to be able to modify.
This is done by selecting the desired cells and either
choosing Format - Format Cells - Protection - Uncheck Locked
or you can add the Lock icon from Tools - Customize - Commands - Format
Menu to an existing toolbar by dragging it.

2. Protecting the worksheet - Locking a cell does nothing until you protect
the sheet. To protect the sheet select Tools - Protection - Protect Sheet
(you can add a password if you wish). Note that even with the sheet protected
even if you add a password a determined end user can unlock the sheet if they
really want to with some simple code from the net...
--
HTH...

Jim Thomlinson


"JED" wrote:

I want to be able to allow others to use an existing worksheet, to complete
information, without allowing them to edit or modify certain cells