Thread: Cell protection
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Vergel Adriano Vergel Adriano is offline
external usenet poster
 
Posts: 857
Default Cell protection

Hi,

Unlock the cells you want users to be able to change. Then protect the sheet.

To unlock cells:

1. Select the range
2. Format-Cells
3. In Protection tab, remove the check on the Lock checkbox



--
Hope that helps.

Vergel Adriano


"G and (ajk)" wrote:

How can you protect a range of cells (for example, Column A) with a password,
but meanwhile allowing users to access all other cells on the sheet?