Thread
:
Can I find out if & where "Freeze Panes" is set
View Single Post
#
2
Posted to microsoft.public.excel.programming
Andy Pope
external usenet poster
Posts: 2,489
Can I find out if & where "Freeze Panes" is set
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
Reply With Quote
Andy Pope
View Public Profile
Find all posts by Andy Pope