protecting locked cells while being able to sort and filter

%3CLINGO-SUB%20id%3D%22lingo-sub-2228151%22%20slang%3D%22en-US%22%3Eprotecting%20locked%20cells%20while%20being%20able%20to%20sort%20and%20filter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2228151%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20worksheet%20that%20has%20some%20columns%20that%20users%20need%20to%20be%20able%20to%20enter%2Fchange%20data%20and%20other%20columns%20with%20formulas%20that%20need%20to%20be%20protected.%26nbsp%3B%20I%20need%20the%20user%20to%20be%20able%20to%20sort%20and%20filter%20on%20the%20columns.%26nbsp%3B%20I%20thought%20I%20had%20it%20figured%20out%20by%20using%20data%20validation%20with%20an%20error%20message.%26nbsp%3B%20that%20seems%20to%20prevent%20typing%20over%20the%20information%20in%20the%20locked%20cell.%26nbsp%3B%20But%2C%20I%20am%20still%20able%20to%20copy%20and%20paste%20in%20the%20locked%20cell.%26nbsp%3B%20I%20unlocked%20all%20cells%2C%20selected%20the%20formula%20cells%2C%20used%20data%20validation%20unchecking%20the%20in-cell%20dropdown%20and%20set%20the%20error%20alert%20to%20STOP%20with%20an%20error%20message%2C%20locked%20the%20formula%20cells%2C%20and%20under%20Protect%20sheet%20I%20have%20checked%20Select%20locked%20cells%2C%20Select%20unlocked%20cells%2C%20sort%2C%20and%20Use%20auto%20filter.%26nbsp%3B%20this%20seems%20to%20do%20everything%20I%20need%20EXCEPT%20prevent%20pasting%20into%20a%20locked%20cell.%26nbsp%3B%20Any%20suggestions%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2228151%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have a worksheet that has some columns that users need to be able to enter/change data and other columns with formulas that need to be protected.  I need the user to be able to sort and filter on the columns.  I thought I had it figured out by using data validation with an error message.  that seems to prevent typing over the information in the locked cell.  But, I am still able to copy and paste in the locked cell.  I unlocked all cells, selected the formula cells, used data validation unchecking the in-cell dropdown and set the error alert to STOP with an error message, locked the formula cells, and under Protect sheet I have checked Select locked cells, Select unlocked cells, sort, and Use auto filter.  this seems to do everything I need EXCEPT prevent pasting into a locked cell.  Any suggestions?

0 Replies