If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
XL2003 Validation Input Msg Problem
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 |
#3
|
|||
|
|||
XL2003 Validation Input Msg Problem
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 |
#4
|
|||
|
|||
XL2003 Validation Input Msg Problem
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Data validation input message | DT | Worksheet Functions | 8 | July 4th, 2004 12:16 AM |
east-asian languages support/chinese input problem | Krum Atsev | Publisher | 1 | May 30th, 2004 09:57 AM |
Combo Box Problem | Charles | Using Forms | 0 | May 28th, 2004 09:15 PM |
Defined Range | Validation List | Tom | Worksheet Functions | 2 | April 5th, 2004 06:02 PM |
Concatenation problem | JE McGimpsey | Worksheet Functions | 0 | March 8th, 2004 09:32 PM |