please try this code to disable checkbox
Code:
ActiveSheet.CheckBox1.Enabled = False