Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find doesn't work if the sheet is protected
I think it is the way you protected the sheet. Make sure when you protect
the sheet that you check "Select Locked cells" and you should be able to select the protected cells but not update and your find should work "ON" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merging cells in a protected work sheet | Excel Discussion (Misc queries) | |||
Merging cells on a protected work sheet | Excel Worksheet Functions | |||
Protected work sheet | Excel Discussion (Misc queries) | |||
Allow custom update button to work while sheet is protected | Excel Discussion (Misc queries) | |||
Tab key don't work in unprotected cells in a protected sheet | Excel Discussion (Misc queries) |