DeanP
07-17-2019, 05:58 AM
I am running a macro triggered by a workbook open event that 'hides' excel and displays a userform:
Private Sub Workbook_Open()
Application.Visible = False
UserForm1.Show
End Sub
When user is done with the userform they click on an image (I'm using it as a button) which closes the userform and returns to the activesheet in the workbook. The code I'm using is:
Private Sub Image2_Click()
Application.Visisble = True
UserForm1.Hide
End Sub
My problem is that whenever the image is clicked, I get a Runtime 438: Object does not support property or method error. Any idea how to resolve this, as I cannot find a solution?
Private Sub Workbook_Open()
Application.Visible = False
UserForm1.Show
End Sub
When user is done with the userform they click on an image (I'm using it as a button) which closes the userform and returns to the activesheet in the workbook. The code I'm using is:
Private Sub Image2_Click()
Application.Visisble = True
UserForm1.Hide
End Sub
My problem is that whenever the image is clicked, I get a Runtime 438: Object does not support property or method error. Any idea how to resolve this, as I cannot find a solution?