none
Freeze first two rows when scrolled down the spreadsheet RRS feed

  • Question

  • Hi There

    Can someone please help me to write a code to freeze first two rows when scrolled down the spreadsheet or is there any other way to do that? I tried to do it using excel "Freeze Panes" option but no luck.

    Thanks heaps


    Thursday, May 9, 2019 1:04 AM

Answers

  • Sub Freeze2()
        Range("A3").Select
        ActiveWindow.FreezePanes = True
    End Sub

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by Saphire77 Sunday, May 12, 2019 11:59 PM
    Thursday, May 9, 2019 7:18 AM
  • That is a mouse setting, not an Excel setting.

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by Saphire77 Sunday, May 12, 2019 11:59 PM
    Friday, May 10, 2019 6:31 AM

All replies

  • Sub Freeze2()
        Range("A3").Select
        ActiveWindow.FreezePanes = True
    End Sub

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by Saphire77 Sunday, May 12, 2019 11:59 PM
    Thursday, May 9, 2019 7:18 AM
  • Thanks again helping me Hans…

    Yes this does freeze first two rows but when I scrolled down its skipped 3 rows at a time. But I need to scrolle row by row.

    I would greatly appreciate if you can help me to get this sorted.

    Thanks heaps



    • Edited by Saphire77 Thursday, May 9, 2019 10:10 PM
    Thursday, May 9, 2019 9:43 PM
  • That is a mouse setting, not an Excel setting.

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by Saphire77 Sunday, May 12, 2019 11:59 PM
    Friday, May 10, 2019 6:31 AM
  • Thanks for your advice Hans, yes I've change mouse settings and now its working perfectly fine…


    Sunday, May 12, 2019 11:59 PM