This will tell you the column and row that is frozen if any.

Sub fndfrz()
If ActiveWindow.FreezePanes = True Then
MsgBox "Column: " & ActiveWindow.SplitColumn & ", _
Row: " & ActiveWindow.SplitRow
End If
End Sub



"Andy Pope" wrote:

Hi,

Sub Macro1()
'
If ActiveWindow.FreezePanes Then
MsgBox "Freeze panes are on"
Else
MsgBox "No Freeze panes"
End If

MsgBox Cells(ActiveWindow.ScrollRow, _
ActiveWindow.ScrollColumn).Address

End Sub

Cheers
Andy

wrote:
From within a macro I would like to be able to determine if "Freeze Panes"
is set for a worksheet and, if so, exactly which rows/columns are frozen.
Is that possible? How?

Thanks!!

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info