Thread: Drop-down list
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spiky Spiky is offline
external usenet poster
 
Posts: 622
Default Drop-down list


A ComboBox would be prefect.

Ken Johnson


Well, it would be nearly perfect. Except that it also must be linked
to a cell, and THAT cell cannot be locked, either.

I find the best way is still a ComboBox since the validation is
stronger. Put its linked cell out of the way, in a hidden row or
column. When you lock the sheet, they won't be able to find it to do
damage. You can still reference the hidden cell.