"if excel window was on the second screen" code syntax

[blue_clouds_mountain]

Hi all,
I have 2 screens in my office. I want to write a code that maximizes Excel when Excel window is positioned on the second screen. I wish this code to be null if Excel window was on the primary screen. I tried a lot but I did not get it to work.
I have the following code. it maximizes Excel on the second screen. how can I alter it to be within if statement instead?
I am a beginner. So, any help will be super appreciated

Please Login or Register  to view this content.

[blue_clouds_mountain]

hi again!
i got an idea! is there a way to ask excel whether its application is on dual screens?
something like

Please Login or Register  to view this content.

do you think that could work?! thanks in advance!

[ByteMarks]

You can get the number of monitors using the EnumDisplayMonitors API

In a standard module

Please Login or Register  to view this content.

Example usage

Please Login or Register  to view this content.

[blue_clouds_mountain]

thanks a lot for your help!
I just realised that this will prevent me from minimizing excel on the main screen! hahaha
it seems challenging indeed!