Code To Freeze Top Row

[Dazzawm]

May sound odd but I have my reasons! I already have macro enabled workbooks and would like a line of code that will freeze the top row when opened un unfreezed when I close. Thanks.

 

[Muhammad_Usman]

You can achieve the functionality you described by adding VBA code to your macro-enabled workbook. Specifically, you can use the `Workbook_Open` and `Workbook_BeforeClose` events to freeze the top row when the workbook is opened and unfreeze it when the workbook is closed.

Here's a sample VBA code that you can add to your workbook's VBA project:

Private Sub Workbook_Open()
    ' This code will run when the workbook is opened
    ActiveWindow.SplitRow = 1
    ActiveWindow.FreezePanes = True
End Sub


Private Sub Workbook_BeforeClose(Cancel As Boolean)
    ' This code will run before the workbook is closed
    ActiveWindow.FreezePanes = False
End Sub

 

[Dazzawm]

You can achieve the functionality you described by adding VBA code to your macro-enabled workbook. Specifically, you can use the `Workbook_Open` and `Workbook_BeforeClose` events to freeze the top row when the workbook is opened and unfreeze it when the workbook is closed.

Here's a sample VBA code that you can add to your workbook's VBA project:

Private Sub Workbook_Open()
    ' This code will run when the workbook is opened
    ActiveWindow.SplitRow = 1
    ActiveWindow.FreezePanes = True
End Sub


Private Sub Workbook_BeforeClose(Cancel As Boolean)
    ' This code will run before the workbook is closed
    ActiveWindow.FreezePanes = False
End Sub

Much obliged squire.