Clear checkbox when workbook open advice

[ipbr21054]

I wish to clear either checkbox on sheet BIKES when a user opens a workbook.

On the BIKES sheet this works to clear checkbox for worksheet activate event

Private Sub Worksheet_Activate()
   CheckBox1 = False
   CheckBox2 = False
End Sub

BUT it doesnt work for workbook open so please advise correct way.

Private Sub Workbook_Open()
Application.EnableEvents = False
Sheets("BIKES") Checkbox1 = False
Sheets("BIKES") Checkbox2 = False
Application.EnableEvents = True
End Sub

 

[6StringJazzer]

You need dots. Try this. Are your checkboxes ActiveX?

Private Sub Workbook_Open()
Application.EnableEvents = False
Sheets("BIKES").Checkbox1 = False
Sheets("BIKES").Checkbox2 = False
Application.EnableEvents = True
End Sub

 

[ipbr21054]

Now sorted thanks all

Private Sub Workbook_Open()
Application.EnableEvents = False
With Sheets("INV")
    .CheckBox1 = False
    .CheckBox2 = False
End With
Application.EnableEvents = True
End Sub

 

[6StringJazzer]

When did sheet INV come into play?

 

[ipbr21054]

I had to change the name as used another sheet.

 

[smozgur]

Now sorted thanks all

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.