I have a list of elements and I would like to deactivate one of them. I do not want to erase it from the list I just want not to be able to choose it when someone tries to do it.
Is there any way to do it?
Thank you in advance
I have a list of elements and I would like to deactivate one of them. I do not want to erase it from the list I just want not to be able to choose it when someone tries to do it.
Is there any way to do it?
Thank you in advance
Do you mean a Data Validation cell with the list option? No type of list allows specific items to be visible but disabled. It is possible to disallow selection of particular items with macros. The strategy is to use the Worksheet_Change event, and check to see if that cell has been changed to a disallowed value. If you, you change the value back to a default value.
If you post your file and describe in more detail I can provide more detailed information.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks