How to freeze a sheet without Freeze Panes

[bthumble]

Hello everyone?

I have a tab labeled "Main" and would like to freeze the data on the tab so that nobody can scroll up and down on the tab so that the macro buttons are always visible. Tried using Freeze Panes but it will still allow a part of the worksheet to be scrolled.

Thanks in advance!

 

[6StringJazzer]

Where are the macro buttons? Preventing scrolling sounds like an imposition on your users.

I give the first row a tall height, put the buttons in the first row, and then freeze panes at row #2. This example does it for rows 1 & 2 for reasons not shown here.

 

[Artik]

Place two procedures in the ThisWorkbook module:

Private Sub Workbook_Activate()
    If ActiveSheet.CodeName = "Sheet1" Then
        Sheet1.ScrollArea = "A1"
    End If
End Sub

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
    If Sh.CodeName = "Sheet1" Then
        Sheet1.ScrollArea = "A1"
    End If
End Sub

Note that sheet code names are used.

Artik