Protected dropdown list at the same time using it. possible?

February 28, 2012 at 14:51:04
Specs: Windows 7
The problem is that when we have unprotected drop-down list it is possible for user to delete it by chance so we need to protect the drop down list to not be able to be deleted at the same time to be possible to use as a drop down list. that is the point that I have also problem. what you are explaining it is ok but it is not the problem. Hope you see now.

See More: Protected dropdown list at the same time using it. possible?

Report •

#1
February 28, 2012 at 17:51:19
1 - Unprotect the sheet
2 - Select the cell(s) with the Drop Down(s)
3 - Right Click...choose Format Cells
4 - Under the Protection tab, uncheck the Locked box
5 - Protect the sheet

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question