ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can't change in-cell dropdown property of cell... (https://www.excelbanter.com/excel-programming/278373-cant-change-cell-dropdown-property-cell.html)

Wexler

Can't change in-cell dropdown property of cell...
 
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.


All times are GMT +1. The time now is 03:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com