AW: Button erzeugen zur Ausführung von Makros
25.01.2005 14:30:07
Makros
So ist der komplette Code.
Private Sub CommandButton1_Click()
Range("A1:D100").Select
Selection.ClearContents
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
Selection.Borders(xlEdgeLeft).LineStyle = xlNone
Selection.Borders(xlEdgeTop).LineStyle = xlNone
Selection.Borders(xlEdgeBottom).LineStyle = xlNone
Selection.Borders(xlEdgeRight).LineStyle = xlNone
Selection.Borders(xlInsideVertical).LineStyle = xlNone
Selection.Borders(xlInsideHorizontal).LineStyle = xlNone
Selection.Interior.ColorIndex = xlNone
Range("A1").Select
Sheets("Tabelle1").Select
ActiveWindow.SmallScroll ToRight:=2
Selection.AutoFilter Field:=12, Criteria1:="Bakir"
ActiveWindow.ScrollColumn = 2
ActiveWindow.ScrollColumn = 1
ActiveWindow.Panes(2).Activate
Range("B1:B100,G1:G100,E1:E100,H1:H100").Select
Range("H45").Activate
Selection.Copy
Sheets("Bakir").Select
ActiveSheet.Paste
Range("C12").Select
ActiveWindow.ScrollWorkbookTabs Sheets:=-1
Sheets("Tabelle1").Select
ActiveWindow.SmallScroll ToRight:=2
Selection.AutoFilter Field:=12
Range("H29").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = " "
Range("A1").Select
Sheets("Bakir").Select
End Sub