You can disable those checkboxes with something like:

ActiveSheet.CheckBoxes("check box 1").Enabled = False

But they won't grey out. You may want to hide them???

ActiveSheet.CheckBoxes("check box 1").Visible = False

robotman wrote:

Thanks! xlOn works....but who at Microsoft developed that?!! Now I
don't feel so bad for not figuring that out. And xlOff = -4146?

My macro will be cross-platform and objects from the VB Toolbox don't
function correctly on a Mac (at least not drop down boxes). I'm not
sure why, but I'm forced to use the Forms toolbox on the worksheet.

** Is there a way to disable (gray out) checkboxes created from the
Forms toolbox? **

so I'm not sure of you Shapes reference; but when I put a CheckBox on a work
sheet, I do it from the Visual Basic ToolBox and draw it directly onto the

When I click off a VB form, the VB ToolBox goes away. Are you talking
about another toolbox like the Controls or Forms from the worksheet
level or am I missing something?

Thanks!

John

--

Dave Peterson