Method 'Range' of object '_Global' failed error message on running userform when another

Hi,

When some other excel file is open and then when i try to run my userform, i get the error message Method 'Range' of object '_Global' failed.

The line of code that is highlighted is ContactForm.Show in ThisWoorkbook.

Kindly help me out on this.

Thanks and Regards
Sivakumar

Hi

You're going to need to post the code from your userform

Hi,

PFB the code.

Private Sub Workbook_Open()
'Application.Visible = False
Call delHyperlinks
ActiveWindow.WindowState = xlMinimized
Application.Visible = False
ContactForm.Show
End Sub

No, not from this_workbook.

We need the code from the userform

Hi Kyle,

Just got it to work...
I used ThisWorkbook.Application.WindowState = xlMinimized in place of ActiveWindow.WindowState = xlMinimized in the code I provided above.

Thanks a lot for your time.

Best Regards
Sivakumar