I have two worksheets in a workbook that won't scroll with the scroll wheel.
How do I make the rest of the work sheets in the same workbook do the same
thing?

Do the other sheet haver Freeze Panes set?
--
www.stfx.ca/people/bliengme


"rcomer123" wrote:

I have two worksheets in a workbook that won't scroll with the scroll wheel.
How do I make the rest of the work sheets in the same workbook do the same
thing?

Yes. The same as the frozen sheets.

"Bernard Liengme" wrote:

Do the other sheet haver Freeze Panes set?
--
www.stfx.ca/people/bliengme


"rcomer123" wrote:

I have two worksheets in a workbook that won't scroll with the scroll wheel.
How do I make the rest of the work sheets in the same workbook do the same
thing?

WindowFreeze Panes.

Play with setting the selected cell at various points.

Perhaps the worksheets that won't scroll have their scrollarea set by code.

Since the scrollarea method does not stick between sessions you will have to
reset it each time you open the workbook.

You may wish to place the code into a WorkBook_Open Sub in ThisWorkbook module
and specify which worksheet if only one sheet required.

Adjust the sheetname and range to suit.

Private Sub WorkBook_Open()
Sheets("YourSheet").ScrollArea = "A1:M56"
End Sub

Or also in the Thisworkbook module to limit scrollarea on all sheets.

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
With ActiveSheet
.ScrollArea = "A1:M56"
End With
End Sub


Gord Dibben MS Excel MVP

On Thu, 17 Apr 2008 16:38:00 -0700, rcomer123
wrote:

I have two worksheets in a workbook that won't scroll with the scroll wheel.
How do I make the rest of the work sheets in the same workbook do the same
thing?

I unfreezed the panes and re-freezed them and now I can scroll on those two
workseets now. Now all I need to figure out is how to make them not scroll.

"Gord Dibben" wrote:

WindowFreeze Panes.

Play with setting the selected cell at various points.

Perhaps the worksheets that won't scroll have their scrollarea set by code.

Since the scrollarea method does not stick between sessions you will have to
reset it each time you open the workbook.

You may wish to place the code into a WorkBook_Open Sub in ThisWorkbook module
and specify which worksheet if only one sheet required.

Adjust the sheetname and range to suit.

Private Sub WorkBook_Open()
Sheets("YourSheet").ScrollArea = "A1:M56"
End Sub

Or also in the Thisworkbook module to limit scrollarea on all sheets.

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
With ActiveSheet
.ScrollArea = "A1:M56"
End With
End Sub


Gord Dibben MS Excel MVP

On Thu, 17 Apr 2008 16:38:00 -0700, rcomer123
wrote:

I have two worksheets in a workbook that won't scroll with the scroll wheel.
How do I make the rest of the work sheets in the same workbook do the same
thing?