View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Tommy Boy Tommy Boy is offline
external usenet poster
 
Posts: 6
Default Protecting cells

Mike

Thanks so much, it worked perfectly. I didn't have the order down right.

Best Tom

"Mike H" wrote:

Hi,

Select the cell where you want the user to enter data and then:-

Format|cells|Protection
Remove the locked checkmark
Protect the sheet with

Tools|Protection|Protect sheet and apply a password if you want and your done.

One small point, this should not be considered secure.

Mike

"Tommy Boy" wrote:

uI'm sure this is simple but jst can't do it.

I have a worksheet with a few cells that I want to enter data into. All the
rest of the worksheet flows from these few enteries. I want to allow the
user access to the data entry cells but prevent any entries into all the rest
of calculated cells. I also want them to be able to see the results of the
calculations.

Any help?