Why wouldn't this be working? i have a sheet called yer maw and one ComboBox1. i write the following code to "ThisWorkbook", save and close. Book opens without any errors, but my combobox contains nothing!! what am i doing wrong?



Private Sub Workbook_Open()


With ActiveWorkbook.Worksheets("yer maw").ComboBox1
    .Clear
    .AddItem "All Decks"
    .AddItem "maw 1"
    .AddItem "ma maw 2"
    .AddItem "his maw 3"
    .AddItem "Deck 4"
    .AddItem "Deck rrr"
End With
End Sub