View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Unlock that linked cell--format|cells|protection tab

Or move it to another location (hidden worksheet or hidden column/row on the
same worksheet??)



Carole O wrote:

Excel 2003
I have a form that uses drop down boxes with a cell link to a column outside
the form(same spreadsheet). When I protect the cell link column, I cannot
select the drop down box (says it is protected - I can see what to select,
just cannot select it). I've designed forms like this before, but haven't
run up against this. Any ideas?

Carole O


--

Dave Peterson