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