Hy zusammen, ich möchte meine Makros die in Jedem Tabellenblatt gespeichert sind in eins zusammenfügen. Das heisst, es ist ein Makro pro Mappe für alle Tabellenblätter gültig. Könnt ihr mir da bitte weiterhelfen?
Danke
Private Sub Workbook_Change(ByVal Target As Range)
If Target.Address(False, False, xlA1) = "Y3" Then
Select Case Target.Value
Case 7.25: Call sechsundreissig_2_0
Case 7.75: Call achtundreissig_2_0
Case 8.25: Call vierzig_2_0
Case 7: Call freitag_2_0
Case 7.8: Call neununddreissig_2_0
End Select
End If
End Sub
Sub keine_produktion()
'
' keine_produktion Makro
' Keine Produktion
'
' Tastenkombination: Strg+ö
'
Range("Z2").Select
ActiveCell.FormulaR1C1 = "0"
Range("AB2").Select
ActiveCell.FormulaR1C1 = "0"
Range("AB3").Select
End Sub
Sub sechsundreissig_2_0()
'
ActiveSheet.Unprotect Password:="12051973GS"
' sechsundreissig_2_0 Makro
' 36,25 Stunden Woche
'
' Tastenkombination: Strg+f
Range("A14").Select
ActiveCell.FormulaR1C1 = "6:00:00 AM"
Range("B14").Select
ActiveCell.FormulaR1C1 = "7:00:00 AM"
Range("A15").Select
ActiveCell.FormulaR1C1 = "7:00:00 AM"
Range("B15").Select
ActiveCell.FormulaR1C1 = "8:00:00 AM"
Range("A16").Select
ActiveCell.FormulaR1C1 = "8:00:00 AM"
Range("B16").Select
ActiveCell.FormulaR1C1 = "8:45:00 AM"
Range("A17").Select
ActiveCell.FormulaR1C1 = "9:00:00 AM"
Range("B17").Select
ActiveCell.FormulaR1C1 = "10:00:00 AM"
Range("A18").Select
ActiveCell.FormulaR1C1 = "10:00:00 AM"
Range("B18").Select
ActiveCell.FormulaR1C1 = "11:00:00 AM"
Range("A19").Select
ActiveCell.FormulaR1C1 = "11:00:00 AM"
Range("B19").Select
ActiveCell.FormulaR1C1 = "12:00:00 PM"
Range("A20").Select
ActiveCell.FormulaR1C1 = "12:15:00 PM"
Range("B20").Select
ActiveCell.FormulaR1C1 = "1:00:00 PM"
Range("A21").Select
ActiveCell.FormulaR1C1 = "1:00:00 PM"
Range("B21").Select
ActiveCell.FormulaR1C1 = "1:45:00 PM"
Range("A22").Select
Selection.ClearContents
Range("B22").Select
Selection.ClearContents
Range("A24").Select
ActiveCell.FormulaR1C1 = "1:45:00 PM"
Range("B24").Select
ActiveCell.FormulaR1C1 = "2:00:00 PM"
Range("A25").Select
ActiveCell.FormulaR1C1 = "2:00:00 PM"
Range("B25").Select
ActiveCell.FormulaR1C1 = "3:00:00 PM"
Range("A26").Select
ActiveCell.FormulaR1C1 = "3:00:00 PM"
Range("B26").Select
ActiveCell.FormulaR1C1 = "4:00:00 PM"
Range("A27").Select
ActiveCell.FormulaR1C1 = "4:00:00 PM"
Range("B27").Select
ActiveCell.FormulaR1C1 = "5:00:00 PM"
Range("A28").Select
ActiveCell.FormulaR1C1 = "5:00:00 PM"
Range("B28").Select
ActiveCell.FormulaR1C1 = "5:30:00 PM"
Range("A29").Select
ActiveCell.FormulaR1C1 = "6:00:00 PM"
Range("B29").Select
ActiveCell.FormulaR1C1 = "7:00:00 PM"
Range("A30").Select
ActiveCell.FormulaR1C1 = "7:00:00 PM"
Range("B30").Select
ActiveCell.FormulaR1C1 = "8:00:00 PM"
Range("A31").Select
ActiveCell.FormulaR1C1 = "8:00:00 PM"
Range("B31").Select
ActiveCell.FormulaR1C1 = "9:00:00 PM"
Range("A32").Select
ActiveCell.FormulaR1C1 = "9:00:00 PM"
Range("B32").Select
ActiveCell.FormulaR1C1 = "9:30:00 PM"
Range("A32").Select
ActiveCell.FormulaR1C1 = "9:00:00 PM"
Range("H22:S22").Select
ActiveSheet.Protect Password:="12051973GS"
End Sub
Sub achtundreissig_2_0()
ActiveSheet.Unprotect Password:="12051973GS"
' achtundreissig_2_0 Makro
' 38 Stunden
'
' Tastenkombination: Strg+h
Range("A14").Select
ActiveCell.FormulaR1C1 = "6:00:00 AM"
Range("B14").Select
ActiveCell.FormulaR1C1 = "7:00:00 AM"
Range("A15").Select
ActiveCell.FormulaR1C1 = "7:00:00 AM"
Range("B15").Select
ActiveCell.FormulaR1C1 = "8:00:00 AM"
Range("A16").Select
ActiveCell.FormulaR1C1 = "8:00:00 AM"
Range("B16").Select
ActiveCell.FormulaR1C1 = "8:45:00 AM"
Range("A17").Select
ActiveCell.FormulaR1C1 = "9:00:00 AM"
Range("B17").Select
ActiveCell.FormulaR1C1 = "10:00:00 AM"
Range("A18").Select
ActiveCell.FormulaR1C1 = "10:00:00 AM"
Range("B18").Select
ActiveCell.FormulaR1C1 = "11:00:00 AM"
Range("A19").Select
ActiveCell.FormulaR1C1 = "11:00:00 AM"
Range("B19").Select
ActiveCell.FormulaR1C1 = "12:00:00 PM"
Range("A20").Select
ActiveCell.FormulaR1C1 = "12:15:00 PM"
Range("B20").Select
ActiveCell.FormulaR1C1 = "1:00:00 PM"
Range("A21").Select
ActiveCell.FormulaR1C1 = "1:00:00 PM"
Range("B21").Select
ActiveCell.FormulaR1C1 = "2:00:00 PM"
Range("A22").Select
ActiveCell.FormulaR1C1 = "2:00:00 PM"
Range("B22").Select
ActiveCell.FormulaR1C1 = "2:15:00 PM"
Range("A24").Select
ActiveCell.FormulaR1C1 = "2:15:00 PM"
Range("B24").Select
ActiveCell.FormulaR1C1 = "3:00:00 PM"
Range("A25").Select
ActiveCell.FormulaR1C1 = "3:00:00 PM"
Range("B25").Select
ActiveCell.FormulaR1C1 = "4:00:00 PM"
Range("A26").Select
ActiveCell.FormulaR1C1 = "4:00:00 PM"
Range("B26").Select
ActiveCell.FormulaR1C1 = "5:00:00 PM"
Range("A27").Select
ActiveCell.FormulaR1C1 = "5:00:00 PM"
Range("B27").Select
ActiveCell.FormulaR1C1 = "6:00:00 PM"
Range("A28").Select
ActiveCell.FormulaR1C1 = "6:00:00 PM"
Range("B28").Select
ActiveCell.FormulaR1C1 = "6:30:00 PM"
Range("A29").Select
ActiveCell.FormulaR1C1 = "7:00:00 PM"
Range("B29").Select
ActiveCell.FormulaR1C1 = "8:00:00 PM"
Range("A30").Select
ActiveCell.FormulaR1C1 = "8:00:00 PM"
Range("B30").Select
ActiveCell.FormulaR1C1 = "9:00:00 PM"
Range("A31").Select
ActiveCell.FormulaR1C1 = "9:00:00 PM"
Range("B31").Select
ActiveCell.FormulaR1C1 = "10:00:00 PM"
Range("A32").Select
ActiveCell.FormulaR1C1 = "10:00:00 PM"
Range("B32").Select
ActiveCell.FormulaR1C1 = "10:30:00 PM"
Range("C32").Select
ActiveSheet.Protect Password:="12051973GS"
End Sub
Sub vierzig_2_0()
ActiveSheet.Unprotect Password:="12051973GS"
' vierzig_2_0 Makro
' 40 Stunden Woche
'
' Tastenkombination: Strg+g
Range("A14").Select
ActiveCell.FormulaR1C1 = "6:00:00 AM"
Range("B14").Select
ActiveCell.FormulaR1C1 = "7:00:00 AM"
Range("A15").Select
ActiveCell.FormulaR1C1 = "7:00:00 AM"
Range("B15").Select
ActiveCell.FormulaR1C1 = "8:00:00 AM"
Range("A16").Select
ActiveCell.FormulaR1C1 = "8:00:00 AM"
Range("B16").Select
ActiveCell.FormulaR1C1 = "8:45:00 AM"
Range("A17").Select
ActiveCell.FormulaR1C1 = "9:00:00 AM"
Range("B17").Select
ActiveCell.FormulaR1C1 = "10:00:00 AM"
Range("A18").Select
ActiveCell.FormulaR1C1 = "10:00:00 AM"
Range("B18").Select
ActiveCell.FormulaR1C1 = "11:00:00 AM"
Range("A19").Select
ActiveCell.FormulaR1C1 = "11:00:00 AM"
Range("B19").Select
ActiveCell.FormulaR1C1 = "12:00:00 PM"
Range("A20").Select
ActiveCell.FormulaR1C1 = "12:15:00 PM"
Range("B20").Select
ActiveCell.FormulaR1C1 = "1:00:00 PM"
Range("A21").Select
ActiveCell.FormulaR1C1 = "1:00:00 PM"
Range("B21").Select
ActiveCell.FormulaR1C1 = "2:00:00 PM"
Range("A22").Select
ActiveCell.FormulaR1C1 = "2:00:00 PM"
Range("B22").Select
ActiveCell.FormulaR1C1 = "2:45:00 PM"
Range("A24").Select
ActiveCell.FormulaR1C1 = "2:45:00 PM"
Range("B24").Select
ActiveCell.FormulaR1C1 = "3:00:00 PM"
Range("A25").Select
ActiveCell.FormulaR1C1 = "3:00:00 PM"
Range("B25").Select
ActiveCell.FormulaR1C1 = "4:00:00 PM"
Range("A26").Select
ActiveCell.FormulaR1C1 = "4:00:00 PM"
Range("A26").Select
ActiveCell.FormulaR1C1 = "4:00:00 PM"
Range("B26").Select
ActiveCell.FormulaR1C1 = "5:00:00 PM"
Range("A27").Select
ActiveCell.FormulaR1C1 = "5:00:00 PM"
Range("B27").Select
ActiveCell.FormulaR1C1 = "6:00:00 PM"
Range("A28").Select
ActiveCell.FormulaR1C1 = "6:00:00 PM"
Range("B28").Select
ActiveCell.FormulaR1C1 = "7:00:00 PM"
Range("A29").Select
ActiveCell.FormulaR1C1 = "7:30:00 PM"
Range("B29").Select
ActiveCell.FormulaR1C1 = "8:00:00 PM"
Range("A30").Select
ActiveCell.FormulaR1C1 = "8:00:00 PM"
Range("B30").Select
ActiveCell.FormulaR1C1 = "9:00:00 PM"
Range("A31").Select
ActiveCell.FormulaR1C1 = "9:00:00 PM"
Range("B31").Select
ActiveCell.FormulaR1C1 = "10:00:00 PM"
Range("A32").Select
ActiveCell.FormulaR1C1 = "10:00:00 PM"
Range("B32").Select
ActiveCell.FormulaR1C1 = "11:30:00 PM"
Range("C32").Select
ActiveSheet.Protect Password:="12051973GS"
End Sub
Sub freitag_2_0()
ActiveSheet.Unprotect Password:="12051973GS"
' freitag_2_0 Makro
' Kurzer Freitag
'
' Tastenkombination: Strg+d
Range("A14").Select
ActiveCell.FormulaR1C1 = "6:00:00 AM"
Range("B14").Select
ActiveCell.FormulaR1C1 = "7:00:00 AM"
Range("A15").Select
ActiveCell.FormulaR1C1 = "7:00:00 AM"
Range("B15").Select
ActiveCell.FormulaR1C1 = "8:00:00 AM"
Range("A16").Select
ActiveCell.FormulaR1C1 = "8:00:00 AM"
Range("B16").Select
ActiveCell.FormulaR1C1 = "8:45:00 AM"
Range("A17").Select
ActiveCell.FormulaR1C1 = "9:00:00 AM"
Range("B17").Select
ActiveCell.FormulaR1C1 = "10:00:00 AM"
Range("A18").Select
ActiveCell.FormulaR1C1 = "10:00:00 AM"
Range("B18").Select
ActiveCell.FormulaR1C1 = "11:00:00 AM"
Range("A19").Select
ActiveCell.FormulaR1C1 = "11:00:00 AM"
Range("B19").Select
ActiveCell.FormulaR1C1 = "12:00:00 PM"
Range("B19").Select
ActiveCell.FormulaR1C1 = "12:00:00 PM"
Range("A20").Select
ActiveCell.FormulaR1C1 = "12:15:00 PM"
Range("B20").Select
ActiveCell.FormulaR1C1 = "1:00:00 PM"
Range("A21").Select
ActiveCell.FormulaR1C1 = "1:00:00 PM"
Range("B21").Select
ActiveCell.FormulaR1C1 = "1:30:00 PM"
Range("A22").Select
Selection.ClearContents
Range("B22").Select
Selection.ClearContents
Range("A24").Select
ActiveCell.FormulaR1C1 = "1:30:00 PM"
Range("B24").Select
ActiveCell.FormulaR1C1 = "2:00:00 PM"
Range("A25").Select
ActiveCell.FormulaR1C1 = "2:00:00 PM"
Range("B25").Select
ActiveCell.FormulaR1C1 = "3:00:00 PM"
Range("A26").Select
ActiveCell.FormulaR1C1 = "3:00:00 PM"
Range("B26").Select
ActiveCell.FormulaR1C1 = "4:00:00 PM"
Range("A27").Select
ActiveCell.FormulaR1C1 = "4:00:00 PM"
Range("A27").Select
ActiveCell.FormulaR1C1 = "4:00:00 PM"
Range("B27").Select
ActiveCell.FormulaR1C1 = "5:00:00 PM"
Range("A28").Select
ActiveCell.FormulaR1C1 = "5:00:00 PM"
Range("B28").Select
ActiveCell.FormulaR1C1 = "5:30:00 PM"
Range("A29").Select
ActiveCell.FormulaR1C1 = "6:00:00 PM"
Range("B29").Select
ActiveCell.FormulaR1C1 = "7:00:00 PM"
Range("A30").Select
ActiveCell.FormulaR1C1 = "7:00:00 PM"
Range("B30").Select
ActiveCell.FormulaR1C1 = "8:00:00 PM"
Range("A31").Select
ActiveCell.FormulaR1C1 = "8:00:00 PM"
Range("B31").Select
ActiveCell.FormulaR1C1 = "9:00:00 PM"
Range("A32").Select
Selection.ClearContents
Range("B32").Select
Selection.ClearContents
Range("F20:G20").Select
ActiveWindow.SmallScroll Down:=-12
Range("E14").Select
ActiveSheet.Protect Password:="12051973GS"
End Sub
Sub neununddreissig_2_0()
'
ActiveSheet.Unprotect Password:="12051973GS"
' neununddreissig Makro
' 39 Stunden Woche
'
' Tastenkombination: Strg+y
'
Range("A14").Select
ActiveCell.FormulaR1C1 = "6:00:00 AM"
Range("B14").Select
ActiveCell.FormulaR1C1 = "7:00:00 AM"
Range("A15").Select
ActiveCell.FormulaR1C1 = "7:00:00 AM"
Range("B15").Select
ActiveCell.FormulaR1C1 = "8:00:00 AM"
Range("A16").Select
ActiveCell.FormulaR1C1 = "8:00:00 AM"
Range("B16").Select
ActiveCell.FormulaR1C1 = "9:00:00 AM"
Range("A17").Select
ActiveCell.FormulaR1C1 = "9:00:00 AM"
Range("B17").Select
ActiveCell.FormulaR1C1 = "10:00:00 AM"
Range("A18").Select
ActiveCell.FormulaR1C1 = "10:30:00 AM"
Range("B18").Select
ActiveCell.FormulaR1C1 = "11:00:00 AM"
Range("A19").Select
ActiveCell.FormulaR1C1 = "11:00:00 AM"
Range("B19").Select
ActiveCell.FormulaR1C1 = "12:00:00 PM"
Range("A20").Select
ActiveCell.FormulaR1C1 = "12:00:00 PM"
Range("B20").Select
ActiveCell.FormulaR1C1 = "1:00:00 PM"
Range("A21").Select
ActiveCell.FormulaR1C1 = "1:00:00 PM"
Range("B21").Select
ActiveCell.FormulaR1C1 = "2:00:00 PM"
Range("A22").Select
ActiveCell.FormulaR1C1 = "2:00:00 PM"
Range("B22").Select
ActiveCell.FormulaR1C1 = "2:30:00 PM"
Range("A24").Select
ActiveCell.FormulaR1C1 = "2:30:00 PM"
Range("B24").Select
ActiveCell.FormulaR1C1 = "3:00:00 PM"
Range("A25").Select
ActiveCell.FormulaR1C1 = "3:00:00 PM"
Range("B25").Select
ActiveCell.FormulaR1C1 = "4:00:00 PM"
Range("A26").Select
ActiveCell.FormulaR1C1 = "4:00:00 PM"
Range("B26").Select
ActiveCell.FormulaR1C1 = "5:00:00 PM"
Range("A27").Select
ActiveCell.FormulaR1C1 = "5:00:00 PM"
Range("B27").Select
ActiveCell.FormulaR1C1 = "6:00:00 PM"
Range("A28").Select
ActiveCell.FormulaR1C1 = "6:00:00 PM"
Range("B28").Select
ActiveCell.FormulaR1C1 = "6:30:00 PM"
Range("A29").Select
ActiveCell.FormulaR1C1 = "7:00:00 PM"
Range("B29").Select
ActiveCell.FormulaR1C1 = "8:00:00 PM"
Range("A30").Select
ActiveCell.FormulaR1C1 = "8:00:00 PM"
Range("B30").Select
ActiveCell.FormulaR1C1 = "9:00:00 PM"
Range("A31").Select
ActiveCell.FormulaR1C1 = "9:00:00 PM"
Range("B31").Select
ActiveCell.FormulaR1C1 = "10:00:00 PM"
Range("A32").Select
ActiveCell.FormulaR1C1 = "10:00:00 PM"
Range("B32").Select
ActiveCell.FormulaR1C1 = "11:00:00 PM"
Range("A33:C34").Select
ActiveSheet.Protect Password:="12051973GS"
End Sub