Dear all,
I'm having a workbook in which I used "Data Validation List" in all the
sheets of workbok.
Unfortunately in one sheet, drop down list arrows are not displaying
although the list is still in the cell.
I checked with contexture website and also I searched in google and tried
with all the guidelines given by them but still it is not working.
I'm still wondering how this drop down arrow is not appearing in one
particular sheet of workbook. All the other worksheets of the same workbook
are showing drop down arrows.
Please help me to sort out this problem.

Click a cell that has the validation in it, go to DataValidation you
should see a checkbox called In-Cell Dropdown make sure its checked,
failing that rename your worksheet, create another with the name of the
original copy the values and formulae over then re-apply your
validation.


--
The Code Cage Team

Regards,
The Code Cage Team
www.thecodecage.com
------------------------------------------------------------------------
The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=7264

Try running this on the worksheet in question

Sub SetInCellDropdown()
Dim r As Range
Dim myTest As Boolean


For Each r In ActiveSheet.UsedRange
myTest = True
On Error Resume Next
myTest = r.Validation.InCellDropdown
On Error GoTo 0
If myTest = False Then
r.Validation.InCellDropdown = True
End If
Next r
End Sub

This assumes that there are entries on the sheet before and after the data
validation.


--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"Premanand Sethuraman" wrote:

Dear all,
I'm having a workbook in which I used "Data Validation List" in all the
sheets of workbok.
Unfortunately in one sheet, drop down list arrows are not displaying
although the list is still in the cell.
I checked with contexture website and also I searched in google and tried
with all the guidelines given by them but still it is not working.
I'm still wondering how this drop down arrow is not appearing in one
particular sheet of workbook. All the other worksheets of the same workbook
are showing drop down arrows.
Please help me to sort out this problem.

Ive had the same problem within the workbook (not only single sheet) which
has caused some grief. Ive had to revert to the VB editor section under
Developer-VB Editor.
Under the 'Microsoft Excel Objects' section select 'This workbook'. The
variable 'DisplayDrawingObjects' was showing '3 - xlHide'; this needed to be
changed to '-4104 - xlDisplayShapes'.

Not sure how this may have got changed!!!

Cheers

"Barb Reinhardt" wrote:

Try running this on the worksheet in question

Sub SetInCellDropdown()
Dim r As Range
Dim myTest As Boolean


For Each r In ActiveSheet.UsedRange
myTest = True
On Error Resume Next
myTest = r.Validation.InCellDropdown
On Error GoTo 0
If myTest = False Then
r.Validation.InCellDropdown = True
End If
Next r
End Sub

This assumes that there are entries on the sheet before and after the data
validation.


--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"Premanand Sethuraman" wrote:

Dear all,
I'm having a workbook in which I used "Data Validation List" in all the
sheets of workbok.
Unfortunately in one sheet, drop down list arrows are not displaying
although the list is still in the cell.
I checked with contexture website and also I searched in google and tried
with all the guidelines given by them but still it is not working.
I'm still wondering how this drop down arrow is not appearing in one
particular sheet of workbook. All the other worksheets of the same workbook
are showing drop down arrows.
Please help me to sort out this problem.