Data Validation Window?
 

Excel 2000 ... I do not use Validation much, but usually
have no problem.

I used COPY/PASTE SPECIAL "Validation" to get Validation
into other cells ... Issue is ... the Validation Message
Window is now opening way off location from the PASTE TO
cells.

Above said ... if I select each cell & set Validation ...
Validation Window appears ajacent to cell where Validation
was set (perfect)... However, when I use COPY/PASTE
SPECIAL Validation ... the Window is appearing to stay
closer to the COPY FROM cell than the PASTE TO cell.

How do I fix this ... other than selecting each cell &
then setting Validation? ... Thanks ... Kha

If any data validation message is moved, all the messages appear in that
position.

To reset them, close then reopen the file.

Ken wrote:
Excel 2000 ... I do not use Validation much, but usually
have no problem.

I used COPY/PASTE SPECIAL "Validation" to get Validation
into other cells ... Issue is ... the Validation Message
Window is now opening way off location from the PASTE TO
cells.

Above said ... if I select each cell & set Validation ...
Validation Window appears ajacent to cell where Validation
was set (perfect)... However, when I use COPY/PASTE
SPECIAL Validation ... the Window is appearing to stay
closer to the COPY FROM cell than the PASTE TO cell.

How do I fix this ... other than selecting each cell &
then setting Validation? ... Thanks ... Kha


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