| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
My data validation cells don't activate when I click on them
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
My data validation cells don't activate when I click on them
Is the "In-cell drop down" box checked when you setup the Data Validation?
HTH Otto "Donique" wrote in message ... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
My data validation cells don't activate when I click on them
And if the answer to Otto's question is "yes", then another place to look is
in: <Tools <Options <View tab, And make sure that under "Objects", 'Hide All' is *NOT* checked. Further, you didn't mention your version, but there is a bug in XL97, where if you use "Freeze Panes" at or under the validation cell, the drop-down will *not* display. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Otto Moehrbach" wrote in message ... Is the "In-cell drop down" box checked when you setup the Data Validation? HTH Otto "Donique" wrote in message ... |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
My data validation cells don't activate when I click on them
if you use "Freeze Panes" at or under the validation cell, the drop-down
will *not* display. if tht is the case, u can use ALT+DOWN ARROW to drop down the list and use arrow key to select.. HTH Joe Ragdyer wrote: And if the answer to Otto's question is "yes", then another place to look is in: <Tools <Options <View tab, And make sure that under "Objects", 'Hide All' is *NOT* checked. Further, you didn't mention your version, but there is a bug in XL97, where if you use "Freeze Panes" at or under the validation cell, the drop-down will *not* display. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Otto Moehrbach" wrote in message ... Is the "In-cell drop down" box checked when you setup the Data Validation? HTH Otto "Donique" wrote in message ... |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
My data validation cells don't activate when I click on them
I'm on an XL97 machine today, and this doesn't work for me.
Maybe I'm not following you. Would you elaborate ... step by step ... for me? -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Joe_Germany" wrote in message oups.com... if you use "Freeze Panes" at or under the validation cell, the drop-down will *not* display. if tht is the case, u can use ALT+DOWN ARROW to drop down the list and use arrow key to select.. HTH Joe Ragdyer wrote: And if the answer to Otto's question is "yes", then another place to look is in: <Tools <Options <View tab, And make sure that under "Objects", 'Hide All' is *NOT* checked. Further, you didn't mention your version, but there is a bug in XL97, where if you use "Freeze Panes" at or under the validation cell, the drop-down will *not* display. -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "Otto Moehrbach" wrote in message ... Is the "In-cell drop down" box checked when you setup the Data Validation? HTH Otto "Donique" wrote in message ... |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
My data validation cells don't activate when I click on them
Im sorry, I havent checked tat on XL97..
But otherwise when u r in such cell, the ALT+DOWN ARROW will drop the list down, like when u click the drop down button.. be in such a cell ALT + DOWN ARROW use UP/DOWN Arrow to select press enter.. Regards Joe Ragdyer wrote: I'm on an XL97 machine today, and this doesn't work for me. Maybe I'm not following you. Would you elaborate ... step by step ... for me? -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Joe_Germany" wrote in message oups.com... if you use "Freeze Panes" at or under the validation cell, the drop-down will *not* display. if tht is the case, u can use ALT+DOWN ARROW to drop down the list and use arrow key to select.. HTH Joe Ragdyer wrote: And if the answer to Otto's question is "yes", then another place to look is in: <Tools <Options <View tab, And make sure that under "Objects", 'Hide All' is *NOT* checked. Further, you didn't mention your version, but there is a bug in XL97, where if you use "Freeze Panes" at or under the validation cell, the drop-down will *not* display. -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "Otto Moehrbach" wrote in message ... Is the "In-cell drop down" box checked when you setup the Data Validation? HTH Otto "Donique" wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro question | Excel Worksheet Functions | |||
| Data validation with hyperlinks | Excel Worksheet Functions | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Data Validation (in a range of cells) | Excel Worksheet Functions | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Hybrid Mode
