I am trying to use everyone's personal workbook to save settings since it is a hidden workbook and it starts with excel. I know I have to Create it on their computer initially but it is worth it. I am trying to test it to see if would work, I am trying to read from it but it isn't working. I am getting an error:
[VBA]If Workbooks("Personal").Range("D1").Value = "Yes" Then Cases.Value = True
If Workbooks("Personal").Range("D2").Value = "Yes" Then Cases.Value = True[/VBA]