View Single Post
  #4   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

Chinita,

Is the checkbox from the Forms toolbar or the Controls Toolbox toolbar? Do
you want it disabled automatically in certain situations, or do you want to
disable it manually? For the former, it will require macro code. To
manually disable a checkbox, if it's from the Controls Toolbox toolbar, put
it in design mode (upper left button in Controls Toolbox),. right-click the
checkbox, select "properties," and set the "enabled" property to false.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"chinita" wrote in message
...
I used check box in excel. Is there a way to disable the check box without
protecting the entire sheet?