A
ama.mau
Guest
hello, cette macro ne marche pas et je ne comprends pas pourquoi :
Function cacher()
Call feuil2.masquer1
cacher = True
End Function
Function montrer()
Call feuil2.afficher1
montrer = True
End Function
Sub masquer1()
ActiveSheet.Rows('71:75').Select
Selection.EntireRow.Hidden = True
Application.ScreenUpdating = True
End Sub
Sub afficher1()
ActiveSheet.Rows('71:75').Select
Selection.EntireRow.Hidden = False
Application.ScreenUpdating = True
End Sub
Function cacher()
Call feuil2.masquer1
cacher = True
End Function
Function montrer()
Call feuil2.afficher1
montrer = True
End Function
Sub masquer1()
ActiveSheet.Rows('71:75').Select
Selection.EntireRow.Hidden = True
Application.ScreenUpdating = True
End Sub
Sub afficher1()
ActiveSheet.Rows('71:75').Select
Selection.EntireRow.Hidden = False
Application.ScreenUpdating = True
End Sub