Druckmenü zeigt nur 8
09.12.2006 13:05:11
Walter
ich mal aus der Recherche eine UF mit einem Druckmenü kopiert und wollte dies
verwenden.
Habe gerade festgestellt es geht nur bis Seite 8, krieg das leider nicht hin das bis zum Ende, in diesem Fall 18 Seiten, man die "Spin-Button" scrollen kann.
Vielleicht blickt jemand durch, hier das Makro:
Option Explicit
Dim bolStart As Boolean
Private Sub CommandButton13_Click()
' Drucken
If Me.OptionButton1 = True Then
Dim s
Dim z As Long
Application.ScreenUpdating = False
Range("A5").Select
z = Range("A5").End(xlDown).Row
ActiveSheet.Range(Cells(6, 1), Cells(z, 12)).Select
With ActiveSheet.PageSetup
.PrintArea = Range(Cells(6, 1), Cells(z, 12)).Address
.PrintTitleRows = "$3:$5"
.LeftFooter = "&8&P von &N"
.RightFooter = "&8 &F / &A &D &T"
.CenterHorizontally = True
.Orientation = xlLandscape
.FitToPagesWide = 1
.FitToPagesTall = False
End With
ActiveSheet.PrintOut Copies:=CLng(Me.SpinButton3.Value)
End If
If Me.OptionButton2 = True Then
ActiveSheet.PrintOut From:=CLng(Me.SpinButton1.Value), _
To:=CLng(Me.SpinButton2.Value), Copies:=CLng(Me.SpinButton3.Value)
End If
Application.ScreenUpdating = True
End Sub
Private Sub CommandButton1_Click()
End Sub
Private Sub CommandButton2_Click()
' Abbrechen
Unload Me
End Sub
Private Sub OptionButton1_Click()
Me.TextBox1.Value = "1"
Me.TextBox2.Value = "1"
End Sub
Private Sub OptionButton2_Click()
End Sub
Private Sub SpinButton1_Change()
If bolStart = False Then
If Me.SpinButton1.Value > Me.SpinButton2.Value Then Me.SpinButton1.Value = Me.SpinButton2.Value
Me.OptionButton2 = True
End If
Me.TextBox1 = Me.SpinButton1.Value
End Sub
Private Sub SpinButton2_Change()
If bolStart = False Then
If Me.SpinButton2.Value < Me.SpinButton1.Value Then Me.SpinButton2.Value = Me.SpinButton1.Value
Me.OptionButton2 = True
End If
Me.TextBox2 = Me.SpinButton2.Value
End Sub
Private Sub SpinButton3_Change()
Me.TextBox3 = Me.SpinButton3.Value
End Sub
Private Sub TextBox1_Change()
End Sub
Private Sub TextBox2_Change()
End Sub
Private Sub UserForm_Initialize()
Dim z
z = Range("A5").End(xlDown).Row
ActiveSheet.Range(Cells(6, 1), Cells(z, 12)).Select
With ActiveSheet.PageSetup
.PrintArea = Range(Cells(6, 1), Cells(z, 12)).Address
.PrintTitleRows = "$3:$5"
End With
Range("A5").Select
bolStart = True
Me.TextBox1 = 1
Me.TextBox2 = CLng(ExecuteExcel4Macro("INDEX(GET.DOCUMENT(50),1)"))
Me.SpinButton1.Min = 1
Me.SpinButton1.Max = CLng(ExecuteExcel4Macro("INDEX(GET.DOCUMENT(50),1)"))
Me.SpinButton2.Min = 1
Me.SpinButton2.Max = CLng(ExecuteExcel4Macro("INDEX(GET.DOCUMENT(50),1)"))
Me.SpinButton3.Value = 1
Me.OptionButton1 = True
bolStart = False
End Sub
Ich würde mich freuen, wenn jemand duchblickt...
mfg Walter