locked
scrollrow possible ? RRS feed

  • Question

  • is it possible from access vba to scroll all pages in a workbook to line 1 ?

    this seems not to work

    For Each ws In objexcel.Worksheets
       
    ws.Activate
       
    ActiveWindow.ScrollColumn = 1
       
    ActiveWindow.ScrollRow = 1
    Next ws

    Sunday, September 29, 2019 8:24 AM

Answers

  • Does this do what you want?

    For Each ws In objExcel.Worksheets
         objExcel.Goto ws.Range("A1"), True
    Next ws


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

    • Marked as answer by tekoko10 Sunday, September 29, 2019 9:48 AM
    Sunday, September 29, 2019 9:00 AM

All replies

  • Does this do what you want?

    For Each ws In objExcel.Worksheets
         objExcel.Goto ws.Range("A1"), True
    Next ws


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

    • Marked as answer by tekoko10 Sunday, September 29, 2019 9:48 AM
    Sunday, September 29, 2019 9:00 AM
  • yes ! thx !
    Sunday, September 29, 2019 9:48 AM