Data Validation Question

C

Casey

The "Input Message" that can be added to Data Validation, has someho
become dissassociated with the cells containing the Data Validation.
In normal operation when you select a cell containing DV, the "Inpu
Message" appears next to and slighty below the selected cell and the
moved as you selected different cells, however on my sheet thos
messages appear in a spot well away from the selected cell and don'
move when you select a different cell.
Is there some way to "re-attach" them to the cells short of removin
the DV and putting it back. Thank
 
J

Juan Pablo González

Close and reopen the workbook. That seems to be the only solution to that.
 
J

jmp

Make sure that the "Office Assistant" is hidden... If
the "Office Assistant" is in animated mode the message
title and the message will appear where the assistant was
last placed on the screen. If the then "Office Assistant"
is hidden, then the message title and message will appear
immediately below the data validation cell.
 
Top