Add window to active workbook and minimize others

[belinda7]

Hello,

I usually have four or five workbooks opened at the same time.

How do I create a macro that will:
1) Add a new window to the active workbook,
2) Arrange the windows horizontally,
3) Switch the view to "Full Screen" and,
4) Minimize all other workbooks.

I am also looking for the flexibility of having a dialog box that comes up at the beginning and allows me to enter the number of new windows to open for the active workbook.

Thank you very much for your help.

 

[SkipVought]

Hi,

Have you tried doing what you want on the sheet in Excel?

Have you tried macro recording?

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}