Locking cells

  • Thread starter Thread starter swmasson
  • Start date Start date
S

swmasson

hi there,

I was wondering if it is possible to Lock a cell so that no-one ca
enter data into it, the reason behind this is because the cell i
update from a different worksheet.

Thank you for your time

Kind Regards

Swmasso
 
Hi

It's possible. Simply protect the sheet - by default all cells are locked
then.

When you want to allow users to access some cells, unlock them before
protecting the sheet (Format.Cells.Protection). When you want to restrict
the access to some cells only, and to allow for rest of worksheet, then
unlock all cells (click on square at top left corner, and uncheck 'Locked'
checkbox on Format.Cells.Protection tab), after that lock cells you want to
restrict the access for user, and than protect the sheet.
 
Thanks for taking time to read my post, i have just managed to d
exactly what i needed.

Thanks again

Swmasso
 
Back
Top