Protecting Linked Cells??

  • Thread starter Thread starter AlanD
  • Start date Start date
A

AlanD

I have a sheet with drop down option boxes, how can I protect the linke
cells (and other cells that contain formulars) from being edited.

Locking the cell and protecting the sheet stops the dropdown box fro
editing the cells.

Is it possible to 'mask' the cells so the information is visible, bu
not editable..


Cheers
Alan :confused
 
How about putting those linked cells in a hidden column (or hidden row)--but
leave it unlocked.

Then use a formula like:

=if(a1="","",a1)

(and lock that cell with the formula.)

If you think that the user may still find and change that linked cell, how about
putting it on another worksheet and hiding that worksheet.

Then the formula would be:

=if(sheet2!a1="","",sheet2!a1)
 
Thank you for your reply. Hiding the rows would mean that the conten
is not viewable.

I am using the dropdown boxes to choose addresses and other options
these are then displayed on the sheet. Editing these fields, an
saving the changes would trash the sheet
 
If the linked cell is unlocked, but hidden, you could have another cell that
points at that linked cell. That formula cell would be locked, but visible.
 
Back
Top