harveya915
Board Regular
- Joined
- Sep 4, 2015
- Messages
- 141
I have a workbook called Call Info 2.0
On this workbook in Sheet1 I have an image. When I click on the image it brings up a UserForm1
It works all fine and dandy, except for, if I have another workbook opened and when I try to click on the image I get an error:
Run-time error '381': Could not set the List property. Invalid Property array index.
When I hit the debug button, it takes me to the Sheet1 code of the Call Info 2.0:
If I close the second workbook and try clicking the image again, it works! Any help would be appreciated.
On this workbook in Sheet1 I have an image. When I click on the image it brings up a UserForm1
It works all fine and dandy, except for, if I have another workbook opened and when I try to click on the image I get an error:
Run-time error '381': Could not set the List property. Invalid Property array index.
When I hit the debug button, it takes me to the Sheet1 code of the Call Info 2.0:
VBA Code:
Sub Image1_Click()
UserForm1.Show vbModeless
End Sub
If I close the second workbook and try clicking the image again, it works! Any help would be appreciated.