View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pugmalion1 Pugmalion1 is offline
external usenet poster
 
Posts: 5
Default Cell Comment Sticks While Using Validation

Hi,

While using validation to create drop-down menus, I have encountered a very
annoying problem. Everytime I open the files in question anew and click on a
cell, one of the cell comments on the worksheet becomes unhidden and hovers
over any cell that I click, completely obscuring it. Because of this, I
can't use any of the drop down menus. The program is essentially frozen at
this point. I can fix the problem by deleting the comment on the offending
cell, but everytime I open the file anew, the problem persists with another
comment on another cell.


Does anyone know why this is happening/how to permanently fix the problem?