View Single Post
  #1   Report Post  
JayS
 
Posts: n/a
Default how do I protect a worksheet and still use a checkbox control

My checkbox function works like this:

When checked, it unhides certain cells, when unchecked, it hides the same
said cells. When I use the protect worksheet function and I click on the
check-box, I get a message saying €śThe cell or chart you are trying to change
is protected and therefore read-only€ť. How can I use the protect worksheet
function and get the check-box function to work?