|
single file, show multiple tabs
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 |
single file, show multiple tabs
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 |
single file, show multiple tabs
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 |
single file, show multiple tabs
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 |
single file, show multiple tabs
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 |
single file, show multiple tabs
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 |
single file, show multiple tabs
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. "JLGWhiz" wrote: Check VBA help for the Arrange property of the Windows collection. Application.Windows.Arrange xlArrangeStyleTiled "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 |
single file, show multiple tabs
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 |
single file, show multiple tabs
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 |
single file, show multiple tabs
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 |
single file, show multiple tabs
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/ex...CH100648381033 It's the Office Excel 2007 UI version of what I did programmatically. So, thank you for some direction-- that helped. "JLGWhiz" wrote: Check VBA help for the Arrange property of the Windows collection. Application.Windows.Arrange xlArrangeStyleTiled "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 |
single file, show multiple tabs
just use Windows / New Window
"Steve" wrote in message ... 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/ex...CH100648381033 It's the Office Excel 2007 UI version of what I did programmatically. So, thank you for some direction-- that helped. "JLGWhiz" wrote: Check VBA help for the Arrange property of the Windows collection. Application.Windows.Arrange xlArrangeStyleTiled "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 |
single file, show multiple tabs
just use Windows / New Window
"Steve" wrote in message ... 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/ex...CH100648381033 It's the Office Excel 2007 UI version of what I did programmatically. So, thank you for some direction-- that helped. "JLGWhiz" wrote: Check VBA help for the Arrange property of the Windows collection. Application.Windows.Arrange xlArrangeStyleTiled "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 |
single file, show multiple tabs
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..... "Patrick Molloy" wrote: just use Windows / New Window "Steve" wrote in message ... 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/ex...CH100648381033 It's the Office Excel 2007 UI version of what I did programmatically. So, thank you for some direction-- that helped. "JLGWhiz" wrote: Check VBA help for the Arrange property of the Windows collection. Application.Windows.Arrange xlArrangeStyleTiled "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 |
single file, show multiple tabs
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..... "Patrick Molloy" wrote: just use Windows / New Window "Steve" wrote in message ... 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/ex...CH100648381033 It's the Office Excel 2007 UI version of what I did programmatically. So, thank you for some direction-- that helped. "JLGWhiz" wrote: Check VBA help for the Arrange property of the Windows collection. Application.Windows.Arrange xlArrangeStyleTiled "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 |
single file, show multiple tabs
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 |
single file, show multiple tabs
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 |
| All times are GMT +1. The time now is 06:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com