Sep 02 2022 02:43 AM
Mit Text befüllte Zelle als Liste, die täglich länger wird:
Öffne ich die Zelle erscheint der die Mitte der Liste:
Ich muss also jedes mal mit dem Curor nach oben scrollen, um zum Anfang der Liste zu gelangen
um einen neuen Eintrag vornehmen zu können:
Auf einem anderen PC erscheint nach dem Öffnen diese Liste gleich am Anfang, ohne dass ich scrollen müsste.
Leider weiß ich nicht, wo ich an meinem Desktop-PC die Einstellung dafür vornehmen kann.
Viele Grüße an alle
Wolfgang
Sep 02 2022 03:17 AM
SolutionWhat speaks against it than pressing the combination CTRL + Home after opening the folder? :))
or with a VBA macro for a sheet...
Private SubWorkbook_Open()
Sheets("yourSheet").Activate
Range("A1").Select
end sub
or VBA macro on the whole workbook.
How to always at cell A1 when opening workbook?
Private Sub Workbook_SheetActivate(ByVal Wsh As Object)
On Error Resume Next
Wsh.Range("A1").Select
End Sub
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
Sep 02 2022 04:17 AM
You wrote: "
What speaks against it than pressing the combination CTRL + Home after opening the folder? :))"
Thank you so much. That helps. Did not know that combination.
macro:
is that also possible gloal within an open cell, as I asked?
(Sorry for by inpropriate english).
Sep 02 2022 10:00 AM
Sep 02 2022 03:17 AM
SolutionWhat speaks against it than pressing the combination CTRL + Home after opening the folder? :))
or with a VBA macro for a sheet...
Private SubWorkbook_Open()
Sheets("yourSheet").Activate
Range("A1").Select
end sub
or VBA macro on the whole workbook.
How to always at cell A1 when opening workbook?
Private Sub Workbook_SheetActivate(ByVal Wsh As Object)
On Error Resume Next
Wsh.Range("A1").Select
End Sub
Hope I was able to help you with this info.
I know I don't know anything (Socrates)