PDA

View Full Version : scroll through excel spreadsheet keeping both ends freezed



shiv.jyp
02-19-2011, 09:23 AM
hi,

by using freeze panes i can just freeze the left columns of a sheet, please suggest a way in which i can freesz columns of both ends of the sheet and scroll the dataa in between.

either using VBA or some excel trick

Help!
Shiv

Benzadeus
02-19-2011, 10:05 AM
Well, I can't figure out a good way of doing this. Here is my try:

Basically, I divided the main sheet creating a new window of the same sheet, clicking on the button as showed in red on the picture.

I used the code at Worksheet Object:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Windows("janelas.xlsx:1").ScrollRow = Windows("janelas.xlsx:2").ScrollRow
End Sub
, where janelas.xlsx is the name of your Workbook.