I have a large worksheet that has about 30 columns. Most of the columns are protected because they have formulas in them. I have five columns that are not locked/protected that have a drop down lists. I always protect the sheet but whenever I used any of the drop down lists, immediately after data is entered the column the sheet then become unprotected. Any ideas why?
Bookmarks