Scroll to next sheet?

**starcrwzr** · 10-26-2009, 11:47 AM

Is there a macro out there that will automatically move the user to column A of the next sheet if they are on column IV and due a right arrow or scroll to the right? Also, if they are on column A and move to the left it will take them to column IV of the previous worksheet?

Here's my problem... We're limited to Excel 2003 here at work and I have some data that is going to take over 600 columns by 8000 rows to display. It would be very cool to move between sheets by simply scrolling off the edge of one onto the next, either left or right.

**Andy Pope** · 10-26-2009, 11:56 AM

I suggest you keep columns A and IV clear of data

code in the Thisworkbook object

Please Login or Register  to view this content.

**JBeaucaire** · 10-26-2009, 12:04 PM

1) On sheet1, don't use column IV, just put a header at the top that says "Next Page" or something like that.
2) On sheet2, don't use column A, just put a header at the top that says "Previous Page" or something like that.
3) Right-click on sheet1 tab and select VIEW CODE
4) Paste in the worksheet event code into the module that appears:

Please Login or Register  to view this content.

5) Right-click on sheet2 tab and select VIEW CODE
6) Paste in the worksheet event code into the module that appears:

Please Login or Register  to view this content.

7) Close the VBEditor
8) Save your sheet

Now try scrolling off the right side of Sheet1 and it will switch you to column B of Sheet2. Try scrolling off the left of Sheet2 and it will switch you to the end of Sheet1....so you can just scroll back and forth.

**JBeaucaire** · 10-26-2009, 12:07 PM

Andy, that is awesome!!

**starcrwzr** · 10-26-2009, 04:16 PM

That works pretty slick Andy! Thanks!

**JBeaucaire** · 10-26-2009, 04:51 PM

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)