On Open selecting Checkboxes

[khansen97]

I am trying to do a workbook_open command. I want checkboxes to be selected when the workbook opens. Here is the code I have

CheckBox13.Value = True

But everytime I open the workbook, I get an object required error and my line listed above is highlighted.

Any suggestions? I think I am missing something and I just can't figure out what it is

 

[cLFlaVA]

You should include which sheet (or form) the checkbox is on.


[tt]Sheets("SheetName").CheckBox13.Value = True[/tt]

*cLFlaVA
----------------------------
Ham and Eggs walks into a bar and asks, "Can I have a beer please?"
The bartender replies, "I'm sorry, we don't serve breakfast.

 

[mrsbean]

With Option Explicit at the beginning of your code, try this:

CheckBox13.Value = -1

Linda