Definable scrolling

you can also use this code in the workbook module

Please Login or Register  to view this content.

then when book is opened in this instance only A1:I10 can be scrolled on sheet 1

Originally Posted by martindwilson

you can also use this code in the workbook module

Please Login or Register  to view this content.

then when book is opened in this instance only A1:I10 can be scrolled on sheet 1

Ok, I tried this, but I got a message saying something about not being able to use macros. I'm new to this and I'm using Excel 2007. I'm not sure what a "macro" is, and when I do a ALT/F11, I don't understand the difference between the "General" section and the "Workbook" section. Do I just copy and paste the info above and then save and close, or do I have to do something additional before closing the "VBA"? (I'm not even sure what the VBA is).

not sure how 2007 is set up,but you should be able to run macros if yoou allow them,then again your company may have set it so you cant!
that code goes in the workbook module
see image

Originally Posted by martindwilson

not sure how 2007 is set up,but you should be able to run macros if yoou allow them,then again your company may have set it so you cant!
that code goes in the workbook module
see image

Excellent! That was very helpful. I managed to finally get one worksheet corrected so that the scroll area was limited to the area I desired. However, I now need to know how to apply this to the other sheets in my workbook. When I open the next sheet and use ALT/F11, I see the same code that I applied to the previous sheet. Do I simply edit the sheet name in the code?

The code I have entered looks like this:

Private Sub Workbook_Open()
Worksheets("Internship 1").ScrollArea = "A1:BX65"
End Sub

Sheet 1 is named "Internship 1". My next sheet is named "Internship 2". I'm not sure if I just edit the name of the sheet on the command line or enter an entirely separate command.

just add it in

Private Sub Workbook_Open()
Worksheets("Internship 1").ScrollArea = "A1:BX65"
Worksheets("Internship 2").ScrollArea = "A10:CD89"
End Sub

Originally Posted by martindwilson

just add it in

Private Sub Workbook_Open()
Worksheets("Internship 1").ScrollArea = "A1:BX65"
Worksheets("Internship 2").ScrollArea = "A10:CD89"
End Sub

Thanks. How do I tag this post as "solved"?

Originally Posted by HuntnPeck

Excellent! That was very helpful. I managed to finally get one worksheet corrected so that the scroll area was limited to the area I desired. However, I now need to know how to apply this to the other sheets in my workbook. When I open the next sheet and use ALT/F11, I see the same code that I applied to the previous sheet. Do I simply edit the sheet name in the code?

The code I have entered looks like this:

Private Sub Workbook_Open()
Worksheets("Internship 1").ScrollArea = "A1:BX65"
End Sub

Sheet 1 is named "Internship 1". My next sheet is named "Internship 2". I'm not sure if I just edit the name of the sheet on the command line or enter an entirely separate command.

Remember, if you change your sheet name, you will have to edit the code to point to the new name. Macros do not update like cell references do to changes, they have to be done manually.

If you send this to others, be sure to warn them about the macros or they will probably either not know to enable them, or choose to disable them when prompted.

To change your post status, use the edit command.

Originally Posted by Tirren

Remember, if you change your sheet name, you will have to edit the code to point to the new name. Macros do not update like cell references do to changes, they have to be done manually.

If you send this to others, be sure to warn them about the macros or they will probably either not know to enable them, or choose to disable them when prompted.

To change your post status, use the edit command.

Ok, thanks for the tip.

Originally Posted by ratcat

Read below in my sig

Cheers

Well, I was actually going to mark this post "solved", but apparently it still needs a tweak. I installed macros for my firsy two worksheets to define the scroll area parameters. The first sheet functions normally, but the second is generating a runtime error 9. I have no idea what that means or what to do about it. Anyone got enough patience left to help me see this through to a successful resolution? I'm sorry to be so much trouble. I'm just a rookie trying to learn as I go. I do appreciate all the help that I've received.