View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Cell Comment Sticks While Using Validation

Those may be data validation input messages, instead of comments. If you
don't need them, you can turn them off. There are instructions he

http://www.contextures.com/xlDataVal04.html

Pugmalion1 wrote:
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?




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html