Forum Discussion

Copper Contributor

Sep 16, 2020

Tabellenblätter fixieren

Hallo, ich habe ein kleines Problem: Es geht um eine Arbeitsmappe, in der mehrere Leute arbeiten müssen. In dieser Datei gibt es einige Tabellenblätter. Es passiert immer wieder, dass Kolle...

excel

NikolinoDE

Gold Contributor

Sep 16, 2020

KHeinig

a possibility with VBA

Sub sheets_fix()
    For i = 1 To Worksheets.Count
    Worksheets(i).Select
    Range("G4").Select
    ActiveWindow.FreezePanes = True
    Next i
    End Sub

untested

I would be happy to know if I could help.

Nikolino
I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

NikolinoDE
Gold Contributor
Sep 16, 2020
The second way you could protect the workbook

via Check / Protect Workbook / Structure and Protect Windows.

Many roads lead to Rome 🙂

I would be happy to know if I could help.

Nikolino
I know I don't know anything (Socrates)