Forum Discussion

KHeinig's avatar
KHeinig
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 Kollegen die Blätter verschieben.

 

Gibt es eine Möglichkeit die Reihenfolge der Tabellenblätter zu fixieren?

 

Vielen Dank für Ihre Hilfe!

excel

2 Replies

Sort By
  • NikolinoDE's avatar
    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's avatar
      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)

Resources