This code works in windows 7 but not in windows 10, they are both using Office 2007.
I even triedCode:oXLSheet.Shapes("Check Box 26").ControlFormat.Value = xlOn
but it still does not work. I'm stumped.Code:oXLSheet.CheckBoxes("Check Box 26").Value = 1