Advertisement
Guest User

Untitled

a guest
Feb 22nd, 2017
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.28 KB | None | 0 0
  1. `Private Sub Worksheet_Change(ByVal Target As Range)
  2. Application.ScreenUpdating = False
  3. ActiveSheet.DisplayPageBreaks = False
  4.  
  5. If Target.Address = "$C$3" Then
  6. If Range("C3") = "Persona Moral" Then
  7. Range("6:14,293:323,519:536").EntireRow.Hidden = True
  8. Range("4:5,15:45,144:152,478:494").EntireRow.Hidden = False
  9. Worksheets("Representantes Legales").Visible = True
  10. Worksheets("Fideicomisarios-Fideicomitentes").Visible = False
  11. Else
  12. If Range("C3") = "Persona Física" Then
  13. Range("6:10,293:294,297:297,300:323,330:330,338:339,519:532").EntireRow.Hidden = False
  14. Range("4:5,11:45,144:152,478:494").EntireRow.Hidden = True
  15. Worksheets("Representantes Legales").Visible = False
  16. Worksheets("Fideicomisarios-Fideicomitentes").Visible = False
  17. Else
  18. If Range("C3") = "Fideicomiso" Then
  19. Range("11:14,533:534,536:536").EntireRow.Hidden = False
  20. Range("4:10,15:532,535:535").EntireRow.Hidden = True
  21. Worksheets("Representantes Legales").Visible = True
  22. Worksheets("Fideicomisarios-Fideicomitentes").Visible = True
  23. Else
  24. If Range("C3") = "" Then
  25. Rows("4:599").Hidden = True
  26. Worksheets("Representantes Legales").Visible = False
  27. Worksheets("Fideicomisarios-Fideicomitentes").Visible = False
  28. End If
  29. End If
  30. End If
  31. End If
  32. End If`
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement