View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ON ON is offline
external usenet poster
 
Posts: 1
Default Find doesn't work if the sheet is protected

I used Protection to create a form where user could move with tab only in
those cells which must be filled in. This worked nicely until I tried to
search (ctrl+f).

When I use "Find next", nothings happens. It doesn't help even though the
cells are unlocked; Find doesn't go there. Only when I choose to unlocked
cells, it works. "Find all" lists all hits, but is inconvenient.

Have you noticed this before? Is there any hints how to fix it?