Locking cells

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
 
A

Arvi Laanemets

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.
 
S

swmasson

Thanks for taking time to read my post, i have just managed to d
exactly what i needed.

Thanks again

Swmasso
 
Top