1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54
| Private Sub CommandButton1_Click()
ActiveSheet.PageSetup.LeftHeader = Replace(TextBox1.Value, Chr(13), "")
ActiveSheet.PageSetup.CenterHeader = Replace(TextBox2.Value, Chr(13), "")
ActiveSheet.PageSetup.RightHeader = Replace(TextBox3.Value, Chr(13), "")
ActiveSheet.PageSetup.LeftFooter = Replace(TextBox4.Value, Chr(13), "")
ActiveSheet.PageSetup.CenterFooter = Replace(TextBox5.Value, Chr(13), "")
ActiveSheet.PageSetup.RightFooter = Replace(TextBox6.Value, Chr(13), "")
Unload Me
End Sub
Private Sub CommandButton2_Click()
Unload Me
End Sub
Private Sub CommandButton3_Click()
Unload EEPP
Sheets("Rapport").Activate
ActiveSheet.PageSetup.LeftHeader = Replace(TextBox1.Value, Chr(13), "")
ActiveSheet.PageSetup.CenterHeader = Replace(TextBox2.Value, Chr(13), "")
ActiveSheet.PageSetup.RightHeader = Replace(TextBox3.Value, Chr(13), "")
ActiveSheet.PageSetup.LeftFooter = Replace(TextBox4.Value, Chr(13), "")
ActiveSheet.PageSetup.CenterFooter = Replace(TextBox5.Value, Chr(13), "")
ActiveSheet.PageSetup.RightFooter = Replace(TextBox6.Value, Chr(13), "")
On Error Resume Next
Application.ScreenUpdating = False
' Afficher le quadrillage
ActiveWindow.DisplayGridlines = False
' Afficher les en-têtes
ActiveWindow.DisplayHeadings = True
' Afficher les barres de défilement
ActiveWindow.DisplayHorizontalScrollBar = True
ActiveWindow.DisplayVerticalScrollBar = True
' Afficher les onglets de classeur
ActiveWindow.DisplayWorkbookTabs = True
'Mode plein écran Désactiver
Application.DisplayFullScreen = False
Sheets("Rapport").Activate
Application.Dialogs(xlDialogPrintPreview).Show
Sheets("MDP").Activate
Application.ScreenUpdating = True
End Sub
Private Sub UserForm_Initialize()
TextBox1.Text = Replace(ActiveSheet.PageSetup.LeftHeader, Chr(13), "")
TextBox2.Text = Replace(ActiveSheet.PageSetup.CenterHeader, Chr(13), "")
TextBox3.Text = Replace(ActiveSheet.PageSetup.RightHeader, Chr(13), "")
TextBox4.Text = Replace(ActiveSheet.PageSetup.LeftFooter, Chr(13), "")
TextBox5.Text = Replace(ActiveSheet.PageSetup.CenterFooter, Chr(13), "")
TextBox6.Text = Replace(ActiveSheet.PageSetup.RightFooter, Chr(13), "")
End Sub |
Partager