check boxes on sheet1

[eds000]

sheet1 is an application form the has been completed by the user, so I do NOT enable the macro when I open the file. The problem is that I have a macro that pulls the data off the application and checks the check boxes to see if they have been checked. I orginally used an "OR" but when that came up with an error I then broke it up as follows but I still get a compliation error. Please help!

If Sheets("Form").CheckBox1.Value = "True" Then sERROR = "RESTRICTION1"
If Sheets("Form").CheckBox2.Value = "True" Then sERROR = "RESTRICTION2"
If Sheets("Form").CheckBox3.Value = "True" Then sERROR = "RESTRICTION3"
If Sheets("Form").CheckBox4.Value = "True" Then sERROR = "RESTRICTION4"
If Sheets("Form").CheckBox5.Value = "True" Then sERROR = "RESTRICTION5"

 

[eds000]

PLEASE HELP- no one know why I get an error message when I check to see if a checkbox has been checked when I disabled the macro. I don't want the application macro running when I use another macro to extract the data.