AW: Laufzeitfehler '1004'
30.09.2014 08:22:20
Hannes
Sub pcs_einblenden()
' pcs_einblenden Makro
Sheets("Choice").Select
Sheets("tab1").Visible = True
Sheets("Choice").Select
Sheets("Saving").Visible = True
Sheets("Choice").Select
Sheets("Fabs").Visible = True
Sheets("Choice").Select
Sheets("Purchase").Visible = True
Sheets("Choice").Select
Sheets("Cost Savings 101101").Visible = True
ActiveWindow.ScrollWorkbookTabs Position:=xlFirst
Sheets("Choice").Select
Sheets("Charts 101101").Visible = True
Sheets("Purchasing Savings 201203").Select
Sheets("Cost Savings 101102").Visible = True
Sheets("Purchasing Savings 201205").Select
Sheets("Charts 101102").Visible = True
Sheets("Purchasing Savings 201205").Select
Sheets("Cost Savings 101104").Visible = True
Sheets("Cost Savings 101101").Select
Sheets("Charts 101104").Visible = True
Sheets("Cost Savings 101102").Select
Sheets("Cost Savings 101110").Visible = True
Sheets("Charts 101101").Select
Sheets("Charts 101110").Visible = True
Sheets("Cost Savings 101102").Select
Sheets("Cost Savings 101114").Visible = True
Sheets("Cost Savings 101104").Select
Sheets("Charts 101114").Visible = True
Range("L61").Select
Sheets("Cost Savings 101104").Select
Sheets("Cost Savings 101121").Visible = True
Sheets("Charts 101104").Select
Sheets("Charts 101121").Visible = True
Sheets("Cost Savings 101114").Select
Sheets("Cost Savings 103118").Visible = True
Sheets("Charts 101114").Select
Sheets("Charts 103118").Visible = True
Sheets("Charts 101114").Select
Sheets("Cost Savings 103119").Visible = True
Sheets("Cost Savings 101121").Select
Sheets("Charts 103119").Visible = True
Sheets("Charts 101121").Select
Sheets("Cost Savings 103139").Visible = True
Sheets("Cost Savings 103118").Select
Sheets("Charts 103139").Visible = True
Sheets("Charts 103118").Select
Sheets("Cost Savings 201203").Visible = True
Sheets("Cost Savings 103119").Select
Sheets("Charts 201203").Visible = True
Sheets("Charts 103119").Select
Sheets("Cost Savings 201205").Visible = True
Sheets("Cost Savings 103139").Select
Sheets("Charts 201205").Visible = True
Sheets("Choice").Select
Range("A1").Select
End Sub
------------------------------------------------------------------------
Sub pcs_ausblenden()
' pcs_ausblenden Makro
Sheets(Array("tab1", "Saving", "Fabs", _
"Purchase")).Select
Sheets("Summary").Activate
ActiveWindow.ScrollWorkbookTabs Sheets:=1
ActiveWindow.ScrollWorkbookTabs Sheets:=1
ActiveWindow.ScrollWorkbookTabs Sheets:=1
ActiveWindow.ScrollWorkbookTabs Sheets:=1
ActiveWindow.ScrollWorkbookTabs Sheets:=1
ActiveWindow.ScrollWorkbookTabs Sheets:=1
ActiveWindow.ScrollWorkbookTabs Sheets:=1
ActiveWindow.ScrollWorkbookTabs Sheets:=1
ActiveWindow.ScrollWorkbookTabs Sheets:=1
ActiveWindow.ScrollWorkbookTabs Sheets:=1
ActiveWindow.ScrollWorkbookTabs Sheets:=1
ActiveWindow.ScrollWorkbookTabs Sheets:=1
ActiveWindow.ScrollWorkbookTabs Sheets:=1
ActiveWindow.ScrollWorkbookTabs Sheets:=1
ActiveWindow.ScrollWorkbookTabs Sheets:=1
ActiveWindow.ScrollWorkbookTabs Sheets:=1
ActiveWindow.ScrollWorkbookTabs Sheets:=1
ActiveWindow.ScrollWorkbookTabs Sheets:=1
ActiveWindow.ScrollWorkbookTabs Sheets:=1
ActiveWindow.ScrollWorkbookTabs Sheets:=1
ActiveWindow.ScrollWorkbookTabs Sheets:=1
Sheets(Array("Summary F&M-PP", "Savings Charts", "Fab & Machine", _
"Purchased Parts & Services", "Cost Savings 101101", "Charts 101101", _
"Cost Savings 101102", "Charts 101102", "Cost Savings 101104", "Charts 101104", _
"Cost Savings 101110", "Charts 101110", "Cost Savings 101114", "Charts 101114", _
"Cost Savings 101121", "Charts 101121", "Cost Savings 103118", "Charts 103118", _
"Cost Savings 103119", "Charts 103119", "Cost Savings 103139", "Charts 103139", _
"Cost Savings 201203", "Charts 201203", "Cost Savings 201205")).Select
Sheets("Summary F&M-PP").Activate
Sheets("Charts 201205").Select Replace:=False
Sheets(Array("Summary", "Savings", "Fabs", _
"Purchase", "Cost Savings 101101", "Charts 101101", _
"Cost Savings 101102", "Charts 101102", "Cost Savings 101104", "Charts 101104", _
"Cost Savings 101110", "Charts 101110", "Cost Savings 101114", "Charts 101114", _
"Cost Savings 101121", "Charts 101121", "Cost Savings 103118", "Charts 103118", _
"Cost Savings 103119", "Charts 103119", "Cost Savings 103139", "Charts 103139", _
"Cost Savings 201203", "Charts 201203", "Charts 201205")).Select
Sheets("Charts 201205").Activate
Sheets("Cost Savings 201205").Select Replace:=False
ActiveWindow.SelectedSheets.Visible = False
ActiveWindow.ScrollWorkbookTabs Position:=xlFirst
Sheets("Choice").Select
Range("A1").Select
End Sub