Thread: [Solved] Return Freeze panes location
View Single Post
 
Old 09-18-2018, 02:21 PM
trevorc trevorc is offline Windows 7 32bit Office 2013
Competent Performer
 
Join Date: Jan 2017
Posts: 173
trevorc will become famous soon enoughtrevorc will become famous soon enough
Default

Yes it is, which made me think this...

Code:
Sub Freeze_Panes() 'button click macro to freeze panes at row 4 and col A or Col H
    If ActiveWindow.SplitColumn = 7 Then
       ActiveWindow.SplitColumn = 0
       ActiveSheet.Shapes("FP").TextFrame.Characters.Text = "Freeze" & vbCrLf & "Pane"
    Else
       ActiveWindow.SplitColumn = 7
       ActiveSheet.Shapes("FP").TextFrame.Characters.Text = "Un-Freze" & vbCrLf & "Pane"
   End If
       ActiveWindow.FreezePanes = True
End Sub
Reply With Quote