View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo
 
Posts: n/a
Default Lock a cell from others to edit?

Hi tb,

I am using an excel in Brazilian portuguese, so, I am not sure if the menus
names are 100% corrects.

Tools | protect | Permit user to edit interval

Than you create an interval that they should not be able to edit, and
protect with a password, protect the spreadsheet also

every time (if the spreadsheet is protect) that you will edit the cell,
excel will ask you for a password (case sensitive)

holpe it helps
I appreciate your feedback
Marcelo from Brazil

"tb" escreveu:

I would like to protect a few cells in my workbook that have formulas from
other users editing?

There are 4 systems linked together, I am the one that builds our workbooks
and I want to be the only one that can edit a formula but allow all other
users to edit data. Is this possible?

Thanks