biker9
asked on
Excel 2013 vba multiple monitor configuration, close all windows except a specific one
Hello experts,
I have a multiple monitor setup, and trying to close all windows except a specific one.
So assuming the sheets open are in:
Windows("Monitors.xlsm:1")
Windows("Monitors.xlsm:2")
Windows("Monitors.xlsm:3")
How do I replace the “Monitors.xlsm” with the current file name?
Make Windows("CurrentfileName.x lsm:1") the active window?
and then close Windows 2 & 3?
Thanks,
biker9
I have a multiple monitor setup, and trying to close all windows except a specific one.
So assuming the sheets open are in:
Windows("Monitors.xlsm:1")
Windows("Monitors.xlsm:2")
Windows("Monitors.xlsm:3")
How do I replace the “Monitors.xlsm” with the current file name?
Make Windows("CurrentfileName.x
and then close Windows 2 & 3?
Thanks,
biker9
ASKER
Sorry, that's not it, I am referring to closing open windows within the workbook, not closing the workbook itself.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you, works perfectly!
Also the workbooks it's closing it will save changes in them..
Open in new window
Saurabh...