I faced Path/file access error when I load the form that has a checkbox with ControlSource property filled. To reproduce issue you can get this file or follow steps below:
- Create and open a blank xlsm workbook.
- Create Userform1 and add a checkbox to it.
- Assign value
Sheet1!A1to ControlSource property of checkbox. - Add following codes to
ThisWorkbookmodule:
Private Sub Workbook_Open()
UserForm1.Show
End Sub
- Save and close.
- Open workbook. You see the form without error.
- Without any doing, close the form and the workbook.
- Re-open the workbook. You see Path/file access error
EDIT:
See the problem in screen recorded video from here.