Hi all,
I've been googling this problem for a while, found several "solutions", but I'm not quite getting any of them to work the way I want.
I'm looking to have the mouse wheel only scroll the A14:G30000 range on a worksheet called FIRE, while leaving all other cells frozen, i.e. rows 1 through 13, and columns H+
I've tried something like this in a module:
Sub LimitScrollArea()
Sheets("FIRE").ScrollArea = "A14:G30000"
End Sub
... but once the other cells scroll off the screen, I can't get them back.
Any help would be greatly appreciated. Thanks!
I've been googling this problem for a while, found several "solutions", but I'm not quite getting any of them to work the way I want.
I'm looking to have the mouse wheel only scroll the A14:G30000 range on a worksheet called FIRE, while leaving all other cells frozen, i.e. rows 1 through 13, and columns H+
I've tried something like this in a module:
Sub LimitScrollArea()
Sheets("FIRE").ScrollArea = "A14:G30000"
End Sub
... but once the other cells scroll off the screen, I can't get them back.
Any help would be greatly appreciated. Thanks!