![]() |
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