Advertisement
Guest User

Untitled

a guest
Jun 17th, 2019
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. Public Sub Workbook_Open()
  2.  
  3. ' Désactivation des évènements
  4. Application.EnableEvents = False
  5.  
  6. ' Put the back color of a button to red
  7. ' line 1
  8. CB1.BackColor = &HC0&
  9.  
  10. ' Modify the RowHeight of a line
  11. ' line 2
  12. ThisWorkbook.Worksheets("Search").Rows("12:12").RowHeight = 800
  13.  
  14. ' Réactive l'évènement
  15. Application.EnableEvents = True
  16.  
  17. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement