Hi All,
In the shared workbook I wanted to protect format and contents of cell E4 where drop down list is given (Validation). all cells apart from E4 are locked so editing is not possible and my all formulas are safe within the worksheet.
Generally validation list not allowing to put any other contents but if I am copy pasting any other cell contents, it is allowing to paste.
If I am locking E4 then drop down is not working, means I can not select other values of drop down and if it is not locked then format of the cell can be change by pasting.
Is there any way to protect format of E4 while cell is unlocked along with only given list values.
Please find attached shared workbook for reference which is protected with blank password.
Thanks
Ganesh.
Bookmarks