View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default Can you highlight locked cells in excell, so you can check i

Click Edit/Find on Excel's menu bar. If all the options are not showing in
the dialog box, then click the Options button. Make sure the "Find what"
field is empty and click the Format button. Go to the Protection tab and
make Locked display a check mark and make Hidden not checked. Press OK to go
back to the Find dialog. Select Sheet in the Within dropdown box and Values
from the LookIn dropdown box. Then click the Find All button and then press
Ctrl+A. You can now click the Close button... all your Locked cells should
be selected.

--
Rick (MVP - Excel)


"Tony" wrote in message
...
Can you highlight locked cells in excell, so you can check you have locked
the right ones, and after checking turn the highlight off