Thread: protect cells in excel, but also allow a search in those cells?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Luke M Luke M is offline
external usenet poster
  
Posts: 2,722
Default protect cells in excel, but also allow a search in those cells?
When you protect the sheet, allow users to select locked cells.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"LindaAlex" wrote:

I need a column protected so it cannot be changed by just anyone, however,
when I protect it, I cannot search for an entry in this column Any
suggestions on how to use the search feature?
--
Linda K
Reply With QuoteReply With Quote