Auto-scrolling multiple sheets


C

Confused

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

Advertisements

S

Spiky

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

Advertisements

C

Confused

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top