Macro to open sheet on specific monitor

[phbryan]

Is it possible to have a macro open and display a sheet on a specific monitor?
I'm recording the macro and manually putting the sheet where i want it on monitor 2, but when i run the macro the sheet displays on monitor 1.

Thank you

[Alf]

Not sure about an Excel solution but there are some OS solutions that may be of interest.

1 PC and two screens then pressing "Windows Logo Key" + P gives you the options: "Computer only", "Duplicate", "Extended" and "Projector only"

If you have several Pc's each with it's own monitor but all connected to the same network there is a freebie from Microsoft called "Mouse without border" where you can control up to 4 PC's with 1 mouse dragging and dropping files from one screen to another.

Alf

[CK76]

If it's for your terminal only...
And if your workbook containing code is on primary (Left) monitor.

You can do something like.

Please Login or Register  to view this content.