I guess I took that too literally. Data validation allows you to choose a list item without sheet protection and I answered as though sheet protection was to be avoided.
So you have a solution?
seems my drop down menus wont work without 'protect sheet', so i will relent to that last....i thought i had it figured out when i switched today to data validation 'input message', but i guess there is a character limit, and some of my lists are quite long...so some worked perfectly, but the longer ones wouldn't paste (...from Word....long or short, neither would paste from Excel). i will keep thinking. thanks for your assist
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
