P
Pete at Sappi Fine Paper
I have a spreadsheet in which the Freeze Panes anchor may or may not be in
the right place. How do I write code to check this? I need to put the code
in the selection_change code for the worksheet, so I don't want to unfreeze
and re-freeze every time I change a cell ... just if it is currently frozen
in the wrong place.
Ideally, what I'm trying to do is something like this:
If ActiveWindow.FreezePanes.Row = 1 Then
ActiveWindow.FreezePanes = False
Range("A2").Select
ActiveWindow.FreezePanes = True
End If
....except that "ActiveWindow.FreezePanes.Row" is not a valid expression.
Would appreciate any help! Thanks.
Pete
the right place. How do I write code to check this? I need to put the code
in the selection_change code for the worksheet, so I don't want to unfreeze
and re-freeze every time I change a cell ... just if it is currently frozen
in the wrong place.
Ideally, what I'm trying to do is something like this:
If ActiveWindow.FreezePanes.Row = 1 Then
ActiveWindow.FreezePanes = False
Range("A2").Select
ActiveWindow.FreezePanes = True
End If
....except that "ActiveWindow.FreezePanes.Row" is not a valid expression.
Would appreciate any help! Thanks.
Pete