View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debra Dalgleish
 
Posts: n/a
Default List Validation and Format

When you protect the worksheet, allow users to edit objects, and unlock
the cells that will be used for data entry.

breadvan579 wrote:
All is working well, but when I try and apply protection to the
worksheet it appears to prevent the Combo box from working.

Can you suggest a simple work around this minor problem.




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html