View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default How to protect a column or columns

Highlight the cells you want to be editable by others, go to Format Cells
Protetion and uncheck Locked.

Next, go to Tools Protection Protect Sheet to lock out all other cells.

Create a password if desired.

when you want to edit the locked cells, go to Tools Protection Unprotect
Sheet.

Make sure to re-protect when you finish.

"Clarence" wrote:

I have created a worksheet and want to protect several cells or columns so
that they can only be changed by me. However there are other cells or
columns that I want accessible to other users.

How can this be done or Can it be done?

Thanks