XL2003 Validation Input Msg Problem

Hi... I need help with the Input message for a cell with data validation (when the Office Assistant is hidden).

In XL2003 the input message normally follows the cursor from one cell to the next (when navigating to cells with data validation that includes an input message).

However, I discovered (by accident) that it's possible to "select" and move the input message. Unfortunately, it seems that once this is done, the input message stays in the same location from that point forward. (This behaviour happens regardless of whether sheet protection is on or off.)

Does anyone know how to "reconnect" the input message to the cursor movement - or prevent this disconnect in the first place?

Thanks!

If you close and reopen the file, the normal message behaviour should
return. AFAIK, you can't prevent it.

Phil wrote:
Hi... I need help with the Input message for a cell with data validation (when the Office Assistant is hidden).

In XL2003 the input message normally follows the cursor from one cell to the next (when navigating to cells with data validation that includes an input message).

However, I discovered (by accident) that it's possible to "select" and move the input message. Unfortunately, it seems that once this is done, the input message stays in the same location from that point forward. (This behaviour happens regardless of whether sheet protection is on or off.)

Does anyone know how to "reconnect" the input message to the cursor movement - or prevent this disconnect in the first place?

Thanks!


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

Thanks muchly Debra... Now why didn't I check something obvious like that??? I really do need help... real help.
Cheers, Phil

"Debra Dalgleish" wrote:

If you close and reopen the file, the normal message behaviour should
return. AFAIK, you can't prevent it.

Phil wrote:
Hi... I need help with the Input message for a cell with data validation (when the Office Assistant is hidden).

In XL2003 the input message normally follows the cursor from one cell to the next (when navigating to cells with data validation that includes an input message).

However, I discovered (by accident) that it's possible to "select" and move the input message. Unfortunately, it seems that once this is done, the input message stays in the same location from that point forward. (This behaviour happens regardless of whether sheet protection is on or off.)

Does anyone know how to "reconnect" the input message to the cursor movement - or prevent this disconnect in the first place?

Thanks!


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

You're welcome. The solution will be obvious to you next time. g

Phil wrote:
Thanks muchly Debra... Now why didn't I check something obvious like that??? I really do need help... real help.
Cheers, Phil

"Debra Dalgleish" wrote:


If you close and reopen the file, the normal message behaviour should
return. AFAIK, you can't prevent it.

Phil wrote:

Hi... I need help with the Input message for a cell with data validation (when the Office Assistant is hidden).

In XL2003 the input message normally follows the cursor from one cell to the next (when navigating to cells with data validation that includes an input message).

However, I discovered (by accident) that it's possible to "select" and move the input message. Unfortunately, it seems that once this is done, the input message stays in the same location from that point forward. (This behaviour happens regardless of whether sheet protection is on or off.)

Does anyone know how to "reconnect" the input message to the cursor movement - or prevent this disconnect in the first place?

Thanks!


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





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