Mamut-Code
07.09.2004 10:29:22
Frank
kann man diese beiden Code verkleinern?
Sub Schutz_Ein()
'
' Schutz_Ein Makro
' Makro am 07.09.2004 von FE aufgezeichnet
'
'
Application.ScreenUpdating = False
Sheets("Auswahl").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("Startseite").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("Einzelsummen").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Gesamtberechnung").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Blindplatten 1").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Diverses 1").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Frontplatten 1").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Gehäuse 1").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Rückwand 1").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Blindplatten 2").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Diverses 2").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Frontplatten 2").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Gehäuse 2").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Rückwand 2").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Blindplatten 3").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Diverses 3").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Frontplatten 3").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Gehäuse 3").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Rückwand 3").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Blindplatten 4").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Diverses 4").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Frontplatten 4").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Gehäuse 4").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Rückwand 4").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Blindplatten 5").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Diverses 5").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Frontplatten 5").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Gehäuse 5").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Rückwand 5").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Blindplatten 6").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Diverses 6").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Frontplatten 6").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Gehäuse 6").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Rückwand 6").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Blindplatten 7").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Diverses 7").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Frontplatten 7").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Gehäuse 7").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Rückwand 7").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Blindplatten 8").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Diverses 8").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Frontplatten 8").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Gehäuse 8").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Rückwand 8").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Blindplatten 9").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Diverses 9").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Frontplatten 9").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Gehäuse 9").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Rückwand 9").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Blindplatten 10").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Diverses 10").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Frontplatten 10").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Gehäuse 10").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("MA Rückwand 10").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("Info").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Sheets("Administrator").Select
Range("A2").Select
Application.ScreenUpdating = True
End Sub
Sub Schutz_Aus()
' Schutz_Aus Makro
' Makro am 07.09.2004 von FE aufgezeichnet
Application.ScreenUpdating = False
Sheets("Auswahl").Select
ActiveSheet.Unprotect
Sheets("Einzelsummen").Select
ActiveSheet.Unprotect
Sheets("Startseite").Select
ActiveSheet.Unprotect
Sheets("MA Gesamtberechnung").Select
ActiveSheet.Unprotect
Sheets("MA Blindplatten 1").Select
ActiveSheet.Unprotect
Sheets("MA Diverses 1").Select
ActiveSheet.Unprotect
Sheets("MA Frontplatten 1").Select
ActiveSheet.Unprotect
Sheets("MA Gehäuse 1").Select
ActiveSheet.Unprotect
Sheets("MA Rückwand 1").Select
ActiveSheet.Unprotect
Sheets("MA Blindplatten 2").Select
ActiveSheet.Unprotect
Sheets("MA Diverses 2").Select
ActiveSheet.Unprotect
Sheets("MA Frontplatten 2").Select
ActiveSheet.Unprotect
Sheets("MA Gehäuse 2").Select
ActiveSheet.Unprotect
Sheets("MA Rückwand 2").Select
ActiveSheet.Unprotect
Sheets("MA Blindplatten 3").Select
ActiveSheet.Unprotect
Sheets("MA Diverses 3").Select
ActiveSheet.Unprotect
Sheets("MA Frontplatten 3").Select
ActiveSheet.Unprotect
Sheets("MA Gehäuse 3").Select
ActiveSheet.Unprotect
Sheets("MA Rückwand 3").Select
ActiveSheet.Unprotect
Sheets("MA Blindplatten 4").Select
ActiveSheet.Unprotect
Sheets("MA Diverses 4").Select
ActiveSheet.Unprotect
Sheets("MA Frontplatten 4").Select
ActiveSheet.Unprotect
Sheets("MA Gehäuse 4").Select
ActiveSheet.Unprotect
Sheets("MA Rückwand 4").Select
ActiveSheet.Unprotect
Sheets("MA Blindplatten 5").Select
ActiveSheet.Unprotect
Sheets("MA Diverses 5").Select
ActiveSheet.Unprotect
Sheets("MA Frontplatten 5").Select
ActiveSheet.Unprotect
Sheets("MA Gehäuse 5").Select
ActiveSheet.Unprotect
Sheets("MA Rückwand 5").Select
ActiveSheet.Unprotect
Sheets("MA Blindplatten 6").Select
ActiveSheet.Unprotect
Sheets("MA Diverses 6").Select
ActiveSheet.Unprotect
Sheets("MA Frontplatten 6").Select
ActiveSheet.Unprotect
Sheets("MA Gehäuse 6").Select
ActiveSheet.Unprotect
Sheets("MA Rückwand 6").Select
ActiveSheet.Unprotect
Sheets("MA Blindplatten 7").Select
ActiveSheet.Unprotect
Sheets("MA Diverses 7").Select
ActiveSheet.Unprotect
Sheets("MA Frontplatten 7").Select
ActiveSheet.Unprotect
Sheets("MA Gehäuse 7").Select
ActiveSheet.Unprotect
Sheets("MA Rückwand 7").Select
ActiveSheet.Unprotect
Sheets("MA Blindplatten 8").Select
ActiveSheet.Unprotect
Sheets("MA Diverses 8").Select
ActiveSheet.Unprotect
Sheets("MA Frontplatten 8").Select
ActiveSheet.Unprotect
Sheets("MA Gehäuse 8").Select
ActiveSheet.Unprotect
Sheets("MA Rückwand 8").Select
ActiveSheet.Unprotect
Sheets("MA Blindplatten 9").Select
ActiveSheet.Unprotect
Sheets("MA Diverses 9").Select
ActiveSheet.Unprotect
Sheets("MA Frontplatten 9").Select
ActiveSheet.Unprotect
Sheets("MA Gehäuse 9").Select
ActiveSheet.Unprotect
Sheets("MA Rückwand 9").Select
ActiveSheet.Unprotect
Sheets("MA Blindplatten 10").Select
ActiveSheet.Unprotect
Sheets("MA Diverses 10").Select
ActiveSheet.Unprotect
Sheets("MA Frontplatten 10").Select
ActiveSheet.Unprotect
Sheets("MA Gehäuse 10").Select
ActiveSheet.Unprotect
Sheets("MA Rückwand 10").Select
ActiveSheet.Unprotect
Sheets("Info").Select
ActiveSheet.Unprotect
Sheets("Administrator").Select
Range("A2").Select
Application.ScreenUpdating = True
End Sub
Gruß
Frank