Want a Macro button that slides the spreadsheet

I have built a form that shows data for two different years, but the spreadsheet is too big to fit the screen. I have columns A and B frozen because they contain row headers. I want to be able to make a button that slides the spreadsheet over perfectly to show the 09 data. I do not want to hide because the user will want to slide back and forth and will be anoyed if they have to unhide everytime.

I have tried some things and the problem I have had is if I record myself sliding, it does not work at different %-zoom levels, and if I have already slid part way and push my button, it slides to far.

Any thoughts?

Hello Caliskier,

Add this to your code. This examples places column "M" at left of the screen.

  ActiveWindow.ScrollColumn = 13

Sincerely,
Leith Ross

Originally Posted by Leith Ross

Hello Caliskier,

Add this to your code. This examples places column "M" at left of the screen.

  ActiveWindow.ScrollColumn = 13

Sincerely,
Leith Ross

AWESOME, so easy, I need to learn VBA