Can't change in-cell dropdown property of cell...

W

Wexler

I have a cell with data validation set to a static list of values.
When the user selects a different cell, I want to deactivate the list
cell (lock it and disable in-cell dropdown). I have 2 columns that I
do this for. I can disable one, but not the other.

Range("N8:N12").Validation.InCellDropdown = False ' works
Range("H8:H12").Validation.InCellDropdown = False ' application or
object defined error

There is no difference in column H and column N, so why won't column H
work???

Thanks for anyone's help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word VBA - Automatic change content of a cell in table using dropdown list 5
Function/Sub to change cell properties 7
Disable Cell and take out Data Validation 5
Disable/enable or lock/unlock cells in VBA dependent on other cells values 2
Locking specific cells 1
Problem sorting a range of columns using VBA 1
Insert cells 1
Loop returns only one value, does not loop & an assignment to columnhow-to problem. 26

Top