Dropdown Box Removal?

[Iragalam]

I have a sheet with a number of dropdown fields. Is there a way to choose
from the dropdown list and fill in the information then finalize the sheet?

By finalize I mean - can the dropdown option be removed while still keeping
what was selected?

Any insight would be a great help

 

[Dave Peterson]

Maybe...

Depends on how these dropdowns are created.

If you used data|validation (in xl2003 menu system), you could remove the
validation.

If you used a combobox from the control toolbox toolbar, you could use a linked
cell. Then delete the combobox when you want. The linked cell shouldn't change
values.

If you used a dropdown from the forms toolbar, then I would guess that you have
a formula that uses a linked cell to get the value of the dropdown. You could
delete the dropdown and the value in the formula cell shouldn't change
(until/unless you change the value in the linked cell).

 

[Iragalam]

Thanks for the response. I am using data|validation, and I just removed that.
Also used a macro so speed things up.

Thanks again.