Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto-scrolling multiple sheets
I've found on here that I can shift-select mulitple sheet tabs to allow the cursor to follow it's
position from one sheet to another, but it doesn't scroll the actual sheet. More explanation, using Excell 2000 (I know, but we don't use it enough to warrant an upgrade). I have a file with 8 sheets in it all with related data. If I scroll to cell AA:120 on sheet one, I want all the other sheets to scroll to that cell as well, ALL THE TIME. It seems I have to shift-select all the sheet tabs first, then scroll, then select the sheet I want to be in, and go from there. Thing is, beyond having to do the shift-select all the time (which I can live with if I have to), the other sheets have the cursor moved to the correct cell, but have not scrolled. After selecting a new sheet tab, I have to hit the arrow keys on the keyboard to "jump-scroll" the sheet to where the cursor now is. So, question is, can I make it so that all the sheets are "scroll locked" to each other so that no matter how I scroll in one sheet (cursor movement, scroll bars, etc) all the other sheets scroll to the same position, and have the cursor in the same cell, and make this a permanent change for the file. I'd also like to lock formatting changes as well, but that's much less important, if I make a cell bold and 12 point type in one sheet, carry that change to all the other sheets automatically. Thanks for any input. Conf. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto-scrolling multiple sheets
Formatting specific cells on every sheet will work if you have all the
sheets selected, that is the easy part. But you do have to have all the sheets selected first, and I'd say you have to do that manually. Excel can't guess which sheets you want to format. If it is always all sheets, maybe you should write a quick macro to do that and put it on a toolbar button or CTRL-ALT-A or something. That would save you some time for your editing process. http://www.mrexcel.com/forum/showthread.php?t=32293 I don't think there is a solution short of VBA Event code for the scrolling issue. But that might slow things down a bit, depending on how you set it up. And I think you'd have to do the same workaround (go to each window and press an arrow key), but VBA could make it automatic and non-visible to the user. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto-scrolling multiple sheets
On Fri, 31 Oct 2008 10:43:03 -0700 (PDT), Spiky wrote:
Formatting specific cells on every sheet will work if you have all the sheets selected, that is the easy part. But you do have to have all the sheets selected first, and I'd say you have to do that manually. Excel can't guess which sheets you want to format. If it is always all sheets, maybe you should write a quick macro to do that and put it on a toolbar button or CTRL-ALT-A or something. That would save you some time for your editing process. http://www.mrexcel.com/forum/showthread.php?t=32293 I don't think there is a solution short of VBA Event code for the scrolling issue. But that might slow things down a bit, depending on how you set it up. And I think you'd have to do the same workaround (go to each window and press an arrow key), but VBA could make it automatic and non-visible to the user. OK, thanks, I'll try the VBA route, see if I can come up with anything. Conf. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scrolling across multiple sheets? | Excel Discussion (Misc queries) | |||
Auto link rows of information from multiple sheets to single sheet | Excel Discussion (Misc queries) | |||
have sheets 2 and 3 scroll the same when scrolling sheet 1? | Excel Discussion (Misc queries) | |||
have sheets 2 and 3 scroll the same when scrolling sheet 1? | Excel Worksheet Functions | |||
How do i auto create multiple files from 1 with multiple sheets | Excel Worksheet Functions |