View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

For hidden cells, I don't think you can do anything besides look and not see
them <g.

But for locked cells, you can use format|conditional formatting (if you're not
using it for something else).

With the range you're concerned about selected, you can use a formula like:
=CELL("protect",A1)
(Change A1 to the activecell)




Merlin wrote:

--

Dave Peterson