-
Solved: Setting using Personal workbook to store settings
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]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules