AW: Automatische Einblendung
09.03.2005 10:24:10
Steffi
Hallo Uwe,
vielen Dank für deine Antwort kann man dies auch in die beiden
unteren Codes einbauen.
Nicht erschrecken der zweite Code ist etwas zu lang (Unwissen)
geht sicherlich auch viel kürzer.
Sub Rechnung _aktivieren()
Application.ScreenUpdating = False
If PasswortHolen("Geben Sie das Passwort ein") <> "Felix" Then
Beep
If MsgBox("Passwort falsch!", vbOKCancel) = vbCancel Then End
Else
For blatt = 7 To Sheets.Count
With Sheets(blatt)
.Unprotect Password:="Felix"
.Cells.EntireColumn.Hidden = False
Sheets("Administrator").Visible = True
End With
Next
Application.ScreenUpdating = False
MsgBox ("Tabellenblattschutz deaktiviert" & Chr(10) & "Tabellenblatt Administrator wird eingeblendet" & Chr(10) & "Preis-Spalten wurden eingeblendet")
Sheets("Rechnung").Activate
Range("C20").Select
End If
End Sub
Sub Von_Rechnung_zu_Lieferschein_wechseln_ohne_speichern()
Application.ScreenUpdating = False
Sheets("BacherSystems").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Sheets("BacherE").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Sheets("BacherJ").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Range("A10").Select
Sheets("Birkenstock").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Range("A10").Select
Sheets("Boewe").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Range("A10").Select
Sheets("Bosal").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Range("A10").Select
Sheets("Comeg").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Range("A10").Select
Sheets("dtm").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Range("A10").Select
Sheets("ENBW").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Range("A10").Select
Sheets("Fauser").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Range("A10").Select
Sheets("Fritz").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Range("A10").Select
Sheets("Grimm").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Range("A10").Select
Sheets("Hafner").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Range("A10").Select
Sheets("Handte").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Range("A10").Select
Sheets("Hawema").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Range("A10").Select
Sheets("Heiss").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Range("A10").Select
Sheets("Herzog").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Range("A10").Select
Sheets("Hipp").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Range("A10").Select
Sheets("HPH").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Range("A10").Select
Sheets("Häfele").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Range("A10").Select
Sheets("Hübner").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Range("A10").Select
Sheets("KW").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Sheets("KellerMarter").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Sheets("Desma").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Sheets("Kuhrau").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Sheets("Kunzmann").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Sheets("M.Martin").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Sheets("Mede").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Sheets("Middex").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Range("A10").Select
Sheets("Oertel").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Range("A10").Select
Sheets("Oswald").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Range("A10").Select
Sheets("Pernuma").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Sheets("PFM").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Sheets("REF").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Range("A10").Select
Sheets("Riedmueller").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Range("A10").Select
Sheets("Rieker").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Range("A10").Select
Sheets("SN").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Sheets("S.Schilling").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Sheets("Sauter").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Range("A10").Select
Sheets("Schott").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Range("A10").Select
Sheets("Schuetz").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Range("A10").Select
Sheets("Selutor").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Range("A10").Select
Sheets("SES").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Sheets("SHW").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Sheets("Solidus").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Range("A10").Select
Sheets("StadtTuttlingen").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Range("A10").Select
Sheets("Stecher").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Range("A10").Select
Sheets("Strom").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Range("A10").Select
Sheets("Treu").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Sheets("TUT Instruments").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Sheets("Typodruck").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Range("A10").Select
Sheets("Vomed").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Range("A10").Select
Sheets("Weber").Select
Range("C9:F100").Select
Selection.EntireColumn.Hidden = True
Range("A10").Select
MsgBox ("Preis-Spalten wurden ausgeblendet" & Chr(10) & "Tabellenblatt Administrator wird ausgeblendet" & Chr(10) & "Tabellenblattschutz aktiviert" & Chr(10) & "Es wird zum Lieferschein-Formular umgeschaltet")
For blatt = 2 To Sheets.Count
Sheets(blatt).Protect Password:="Felix"
Next
Application.ScreenUpdating = False
Sheets("Administrator").Visible = xlVeryHidden
Application.ScreenUpdating = True
Sheets("Lieferschein").Select
End Sub
Dank
Steffi