Howdee all.
I have a need to show multiple tabs of a single workbook simultaneously.
In much the same way as one can do with multiple files-- cascade,
horizontal, tiled, vertical......
Is there any code to do this with?
Your helps are deeply appreciated.
Best.
SteveB

Do you mean multiple sheets at the same time?

"Steve" wrote in message
...
Howdee all.
I have a need to show multiple tabs of a single workbook simultaneously.
In much the same way as one can do with multiple files-- cascade,
horizontal, tiled, vertical......
Is there any code to do this with?
Your helps are deeply appreciated.
Best.
SteveB

Good morning Howard.
Ok, Single xlsx file is open.
I want to view two tabs (two worksheets within the single file)
simultaneously-- in the same manner that I can view two different files
simultaneously by arranging the windows by vertical, cascade, tiled, or
horizontal.

I looked in the help file as JLG said, and the windows arrange.... only
works for multiple FILES, not a single FILE on multiple worksheets. Unless
I'm missing something, which wouldn't surprise me at this point.....

Can this be done programmatically? -- since you can't do it without
creating a second file/workbook to place the other worksheet into.

Thank you for your help....



"Howard31" wrote:

Do you mean multiple sheets at the same time?

"Steve" wrote in message
...
Howdee all.
I have a need to show multiple tabs of a single workbook simultaneously.
In much the same way as one can do with multiple files-- cascade,
horizontal, tiled, vertical......
Is there any code to do this with?
Your helps are deeply appreciated.
Best.
SteveB

i don't get the question. in 2003 menu Tools/Options View tab, check the
Sheet Tabs box

2007 look in excel options / advanced then Display Options for This Workbook



"Steve" wrote in message
...
Howdee all.
I have a need to show multiple tabs of a single workbook simultaneously.
In much the same way as one can do with multiple files-- cascade,
horizontal, tiled, vertical......
Is there any code to do this with?
Your helps are deeply appreciated.
Best.
SteveB

Good morning Patrick,
Did as you said, I don't see anything that will allow the user to view
multiple worksheets within a single file simultaneously, as you can with
multiple files.

My goal is to display two different worksheets (within the single
file/workbook) as horizontally displayed to compare the data on each, to
verify accuracy between the two-- without having to switch back and forth
between each one.... it gets rather tedious/frustrating doing it manually.

Thank you for your help.


"Patrick Molloy" wrote:

i don't get the question. in 2003 menu Tools/Options View tab, check the
Sheet Tabs box

2007 look in excel options / advanced then Display Options for This Workbook



"Steve" wrote in message
...
Howdee all.
I have a need to show multiple tabs of a single workbook simultaneously.
In much the same way as one can do with multiple files-- cascade,
horizontal, tiled, vertical......
Is there any code to do this with?
Your helps are deeply appreciated.
Best.
SteveB

oh sorry. then in 2003 use, from the standard menu Window / New Window then
Window / Arrange


"Steve" wrote in message
...
Good morning Patrick,
Did as you said, I don't see anything that will allow the user to view
multiple worksheets within a single file simultaneously, as you can with
multiple files.

My goal is to display two different worksheets (within the single
file/workbook) as horizontally displayed to compare the data on each, to
verify accuracy between the two-- without having to switch back and forth
between each one.... it gets rather tedious/frustrating doing it manually.

Thank you for your help.


"Patrick Molloy" wrote:

i don't get the question. in 2003 menu Tools/Options View tab, check the
Sheet Tabs box

2007 look in excel options / advanced then Display Options for This
Workbook



"Steve" wrote in message
...
Howdee all.
I have a need to show multiple tabs of a single workbook
simultaneously.
In much the same way as one can do with multiple files-- cascade,
horizontal, tiled, vertical......
Is there any code to do this with?
Your helps are deeply appreciated.
Best.
SteveB

Hi again.
Ok, don't use 2003 (am using 2007), and from what I can remember-- it didn't
have access that way back then either.
All to say that I've already tried those options before I posted.

At this point I'm curious if I can force the multiple arranged worksheets by
creating a UDF. Ever done that before?

Again, thank you for your help.


"Patrick Molloy" wrote:

oh sorry. then in 2003 use, from the standard menu Window / New Window then
Window / Arrange


"Steve" wrote in message
...
Good morning Patrick,
Did as you said, I don't see anything that will allow the user to view
multiple worksheets within a single file simultaneously, as you can with
multiple files.

My goal is to display two different worksheets (within the single
file/workbook) as horizontally displayed to compare the data on each, to
verify accuracy between the two-- without having to switch back and forth
between each one.... it gets rather tedious/frustrating doing it manually.

Thank you for your help.


"Patrick Molloy" wrote:

i don't get the question. in 2003 menu Tools/Options View tab, check the
Sheet Tabs box

2007 look in excel options / advanced then Display Options for This
Workbook



"Steve" wrote in message
...
Howdee all.
I have a need to show multiple tabs of a single workbook
simultaneously.
In much the same way as one can do with multiple files-- cascade,
horizontal, tiled, vertical......
Is there any code to do this with?
Your helps are deeply appreciated.
Best.
SteveB

Steve, see if this helps.

Sub dk()
ActiveWorkbook.NewWindow
Windows.Arrange xlArrangeStyleVertical
Windows(2).Activate
Sheets(2).Activate
End Sub





"Steve" wrote:

Hi again.
Ok, don't use 2003 (am using 2007), and from what I can remember-- it didn't
have access that way back then either.
All to say that I've already tried those options before I posted.

At this point I'm curious if I can force the multiple arranged worksheets by
creating a UDF. Ever done that before?

Again, thank you for your help.


"Patrick Molloy" wrote:

oh sorry. then in 2003 use, from the standard menu Window / New Window then
Window / Arrange


"Steve" wrote in message
...
Good morning Patrick,
Did as you said, I don't see anything that will allow the user to view
multiple worksheets within a single file simultaneously, as you can with
multiple files.

My goal is to display two different worksheets (within the single
file/workbook) as horizontally displayed to compare the data on each, to
verify accuracy between the two-- without having to switch back and forth
between each one.... it gets rather tedious/frustrating doing it manually.

Thank you for your help.


"Patrick Molloy" wrote:

i don't get the question. in 2003 menu Tools/Options View tab, check the
Sheet Tabs box

2007 look in excel options / advanced then Display Options for This
Workbook



"Steve" wrote in message
...
Howdee all.
I have a need to show multiple tabs of a single workbook
simultaneously.
In much the same way as one can do with multiple files-- cascade,
horizontal, tiled, vertical......
Is there any code to do this with?
Your helps are deeply appreciated.
Best.
SteveB

Steve, see if this helps.

Sub dk()
ActiveWorkbook.NewWindow
Windows.Arrange xlArrangeStyleVertical
Windows(2).Activate
Sheets(2).Activate
End Sub





"Steve" wrote:

Hi again.
Ok, don't use 2003 (am using 2007), and from what I can remember-- it didn't
have access that way back then either.
All to say that I've already tried those options before I posted.

At this point I'm curious if I can force the multiple arranged worksheets by
creating a UDF. Ever done that before?

Again, thank you for your help.


"Patrick Molloy" wrote:

oh sorry. then in 2003 use, from the standard menu Window / New Window then
Window / Arrange


"Steve" wrote in message
...
Good morning Patrick,
Did as you said, I don't see anything that will allow the user to view
multiple worksheets within a single file simultaneously, as you can with
multiple files.

My goal is to display two different worksheets (within the single
file/workbook) as horizontally displayed to compare the data on each, to
verify accuracy between the two-- without having to switch back and forth
between each one.... it gets rather tedious/frustrating doing it manually.

Thank you for your help.


"Patrick Molloy" wrote:

i don't get the question. in 2003 menu Tools/Options View tab, check the
Sheet Tabs box

2007 look in excel options / advanced then Display Options for This
Workbook



"Steve" wrote in message
...
Howdee all.
I have a need to show multiple tabs of a single workbook
simultaneously.
In much the same way as one can do with multiple files-- cascade,
horizontal, tiled, vertical......
Is there any code to do this with?
Your helps are deeply appreciated.
Best.
SteveB

Hi again.
Ok, don't use 2003 (am using 2007), and from what I can remember-- it didn't
have access that way back then either.
All to say that I've already tried those options before I posted.

At this point I'm curious if I can force the multiple arranged worksheets by
creating a UDF. Ever done that before?

Again, thank you for your help.


"Patrick Molloy" wrote:

oh sorry. then in 2003 use, from the standard menu Window / New Window then
Window / Arrange


"Steve" wrote in message
...
Good morning Patrick,
Did as you said, I don't see anything that will allow the user to view
multiple worksheets within a single file simultaneously, as you can with
multiple files.

My goal is to display two different worksheets (within the single
file/workbook) as horizontally displayed to compare the data on each, to
verify accuracy between the two-- without having to switch back and forth
between each one.... it gets rather tedious/frustrating doing it manually.

Thank you for your help.


"Patrick Molloy" wrote:

i don't get the question. in 2003 menu Tools/Options View tab, check the
Sheet Tabs box

2007 look in excel options / advanced then Display Options for This
Workbook



"Steve" wrote in message
...
Howdee all.
I have a need to show multiple tabs of a single workbook
simultaneously.
In much the same way as one can do with multiple files-- cascade,
horizontal, tiled, vertical......
Is there any code to do this with?
Your helps are deeply appreciated.
Best.
SteveB

i don't get the question. in 2003 menu Tools/Options View tab, check the
Sheet Tabs box

2007 look in excel options / advanced then Display Options for This Workbook



"Steve" wrote in message
...
Howdee all.
I have a need to show multiple tabs of a single workbook simultaneously.
In much the same way as one can do with multiple files-- cascade,
horizontal, tiled, vertical......
Is there any code to do this with?
Your helps are deeply appreciated.
Best.
SteveB