Silly Visual Basic question

Ok, I have some basics about visual basic but I have a problem here:

I looked into the help thing for at least an hour and still can’t figure it out, so I’m turning to the dopers:

How do I do to have the checkboxes in an excell sheet to be automaticly activated when I open the worksheet? What I mean is that when I open the worksheet, that if I click on it, the check box either checks or unchecks and that I can’t move it around by drag and drop…

I tried checkbox1.activate
but it doesn’t seem to do the trick…

so, anyone knows what I should do?

checkbox1.value = 1 (i could open up a project and make sure, but I’m almost positive)