View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
phil[_2_] phil[_2_] is offline
external usenet poster
 
Posts: 1
Default When using an Option Button can I...

Lock a particular cell?

I have optYes and optNo. When optYes is selected I would
like the contents of cell M42 on worksheet WS2 to have a
"locked" state, whereas no data can be entered. And when
optNo is selected I would like the contents to be fully
editable. Is there such a work-around for this?

Thanks in advance for your help.

Phil Diederich