View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron@Buy Ron@Buy is offline
external usenet poster
 
Posts: 345
Default How do you prevent users from changing certain cells?

Kelly
It sounds like the cell you refer to is not formatted for protection.
Try:
Tools Protection Unprotect sheet
Format Cells Protection tab 'click' on box against Locked to enter tick
Tools Protection Protect sheet
This should ptotect said cell


"Kelly" wrote:

I would like to allow users to change certain cells but not the formulas in
other cells. The "Protection" feature doesn't prevent someone from changing
one of the cells with formulas.
Thanks.