ich habe 2 Module die ich auf einen Button legen möchte, quasi für ein und aus. Wie mache ich das ?
Gruß
Benny
Sub Ansichtsfenster()
Dim aktTbl1 As Worksheet, aktTbl2 As Worksheet
Set aktTbl1 = Worksheets("Beschaffungsanlage")
Set aktTbl2 = Worksheets("Portfolio")
aktTbl2.Unprotect "bebomt"
ActiveWindow.NewWindow
Windows.Arrange ArrangeStyle:=xlVertical
Windows("Beschaffungsanlage PC-Komponenten Vers. 1.xls:2").Activate
aktTbl2.Select
ActiveWindow.Zoom = 73
Range("B2").Select
With ActiveWindow
.Top = 0.25
.Left = 422.5
.Width = 535.5
.Height = 624.75
End With
aktTbl1.Unprotect "bebomt"
Windows("Beschaffungsanlage PC-Komponenten Vers. 1.xls:1").Activate
aktTbl1.Select
ActiveWindow.Zoom = 84
Range("B9").Select
With ActiveWindow
.Top = 1.75
.Left = 1
.Width = 421.5
.Height = 624.75
End With
ActiveSheet.Protect "bebomt"
End Sub
Private Sub ToggleButton1_Click()
If ToggleButton1.Value = True Then
Sheets("Portfolio").Visible = False
Else: Sheets("Portfolio").Visible = True
End If
End Sub
Sub Ansichtsfenster()
Dim aktTbl1 As Worksheet, aktTbl2 As Worksheet
Set aktTbl1 = Worksheets("Beschaffungsanlage")
Set aktTbl2 = Worksheets("Portfolio")
aktTbl2.Unprotect "bebomt"
ActiveWindow.NewWindow
Windows.Arrange ArrangeStyle:=xlVertical
Windows("Beschaffungsanlage PC-Komponenten Vers. 2.xls:2").Activate
aktTbl2.Select
ActiveWindow.Zoom = 73
Range("B2").Select
With ActiveWindow
.Top = 0.25
.Left = 422.5
.Width = 535.5
.Height = 624.75
End With
aktTbl1.Unprotect "bebomt"
Windows("Beschaffungsanlage PC-Komponenten Vers. 2.xls:1").Activate
aktTbl1.Select
ActiveWindow.Zoom = 84
Range("B9").Select
With ActiveWindow
.Top = 1.75
.Left = 1
.Width = 421.5
.Height = 624.75
End With
ActiveSheet.Protect "bebomt"
End Sub