Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving data validation input comments
I have three separate data validation input comments on one screen and I would like to control where they appear. Currently there are three separate locations for the messages. If I move one of the input comment to the desired locataion, the other two are automatically put in the same spot - not the desired result and Excel doesn't remember where I move it to when I save the spreadsheet. I'm in 2007 but I'm saving the workbook to make it 2003 compatible. What am I missing? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving data validation input comments
Okay - found out that having all three appear in the same location is a known
oddity that has been documented. But why doesn't it remember where the input comments were moved to (after it was saved)? "Brad" wrote: I have three separate data validation input comments on one screen and I would like to control where they appear. Currently there are three separate locations for the messages. If I move one of the input comment to the desired locataion, the other two are automatically put in the same spot - not the desired result and Excel doesn't remember where I move it to when I save the spreadsheet. I'm in 2007 but I'm saving the workbook to make it 2003 compatible. What am I missing? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Input Validation | Excel Discussion (Misc queries) | |||
Moving data in one excel column to another sheet based on user input | Excel Discussion (Misc queries) | |||
Data Validation Input Message | Excel Discussion (Misc queries) | |||
Data Validation and Input Mask | Excel Discussion (Misc queries) | |||
Comments using Validation input | Excel Discussion (Misc queries) |