single file, show multiple tabs

[Steve]

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

 

[Howard31]

Do you mean multiple sheets at the same time?

 

[Patrick Molloy]

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]

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....

 

[Steve]

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.

 

[Steve]

Hi JLG,
Ok, I looked it up, and printed it out....
This appears to be strictly for arranging windows of different workbooks.

My goal is to do this exact same thing for different worksheets, within a
single workbook.
I see where I can synchronize the scrolling between two sheets of the
different files-- that's <really> helpful to know. It's irksome having to go
back and forth between workbooks when scrolling. I'd also seen a discussion
on the MSDN library about a side-by-side operation. I'll need to study that
one more thoroughly too, as it also looks really helpful.

Thank you for your help.

 

[Patrick Molloy]

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

 

[Steve]

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.

 

[Steve]

Hi again JLG,
While this didn't specifically solve my question, I found something in the
Windows Collection that appears to be as close as I'll get.
It's called comparesidebysidewith()
In an O'Rielly book I found in my search, called Programming Excel with VBA
& .Net, ISBN 0-596-00766-3.
It offers chapter 7 as an example, and on the 62nd, and 63rd pages, it shows
this, as well as some sample code.
What it allows the user to do is to create a copy of the file, and open that
copy, and it then sync's the scroll to scroll both worksheets, in two
separate files, together-- thus allowing me to perform the task that I
sought.

And then one of my colleagues helped me do some digging and found the
following.
http://office.microsoft.com/en-us/excel/HP012170431033.aspx?pid=CH100648381033

It's the Office Excel 2007 UI version of what I did programmatically.

So, thank you for some direction-- that helped.

 

[Patrick Molloy]

just use Windows / New Window

Hi again JLG,
While this didn't specifically solve my question, I found something in the
Windows Collection that appears to be as close as I'll get.
It's called comparesidebysidewith()
In an O'Rielly book I found in my search, called Programming Excel with
VBA
& .Net, ISBN 0-596-00766-3.
It offers chapter 7 as an example, and on the 62nd, and 63rd pages, it
shows
this, as well as some sample code.
What it allows the user to do is to create a copy of the file, and open
that
copy, and it then sync's the scroll to scroll both worksheets, in two
separate files, together-- thus allowing me to perform the task that I
sought.

And then one of my colleagues helped me do some digging and found the
following.
http://office.microsoft.com/en-us/excel/HP012170431033.aspx?pid=CH100648381033

It's the Office Excel 2007 UI version of what I did programmatically.

So, thank you for some direction-- that helped.

 

[Steve]

Thanks Patrick,
I got that AFTER I read the article that I provided the link to.
As I was attempting to avoid having two windows open, I kept bypassing that,
hoping to maintain a single window, and show two worksheets.
Still got a learning curve going.....

 

[JLGWhiz]

Steve, see if this helps.

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