In my Excel 365 worksheet: I want to lock my worksheet "Home" but just let a data validation value box (not form or active-x combobox), assigned to a cell ("I6"), operatable.
That means the users shall be able to select a value from the data validation box, but not be able to change the format and other things.
I have tried so manythings but didnt work. In general I have tried this way:
But each time the worksheet gets protected, an I cannot select a value from the data validation value-box in cell "I6".![]()
Please Login or Register to view this content.
When I comment out the line starting with .Protect, the whole sheet gets unprotected. So I am sure that there is no other code part that is causing the issue.
Bookmarks