Force Excel to always open on Primary Monitor

[kgartin]

I have 3 monitors. Excel seems to arbitrarily open on one of the other two monitors other than the primary. If I move Excel to the primary monitor, open a new worksheet (in the same monitor) and then close Excel, it opens in the primary thereafter.

I want to find a way to ALWAYS under any and all circumstances open Excel in the Primary window.

I found something in a search that says to do this:

Private Sub Workbook_Open()
Application.Top = 0
Application.Left = 0
End Sub

but I get a Run-Time error '1004': Method 'Top' of object'_Application' failed

Help?

 

[rlv01]

Try this

Private Sub Workbook_Open()
   Application.WindowState = xlNormal
   Application.Top = 0
   Application.Left = 0
  Application.WindowState = xlMaximized
End Sub

 

[kgartin]

Try this

Private Sub Workbook_Open()
   Application.WindowState = xlNormal
   Application.Top = 0
   Application.Left = 0
  Application.WindowState = xlMaximized
End Sub

Yessir, that did it! Thanks!

 

[beetle12]

Yessir, that did it! Thanks!

Where did you paste this code? I'm only seeing workbook-specific ways to add this in, and it looks like you applied it to ALL Excel files, which is what I'm hoping to do, as well.