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 55 56 57 58 59 60 61 62 63 64 65 66 67
| Private Sub Image1_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
If X < 10 Or X > Image1.Width - 10 Or Y < 10 Or Y > Image1.Height - 10 Then
ActiveSheet.Shapes("Bretagne").Fill.ForeColor.RGB = RGB(255, 255, 255) 'Couleur de fond blanc
ActiveSheet.Shapes("Label1").Fill.ForeColor.RGB = RGB(255, 255, 0) 'Couleur de fond jaune
ActiveSheet.Shapes("Label1").Visible = False
ActiveSheet.Shapes("Label_info1").Fill.ForeColor.RGB = RGB(102, 101, 255) 'Couleur de fond jaune
ActiveSheet.Shapes("Label_info1").Visible = False
Else
ActiveSheet.Shapes("Label1").Visible = True
ActiveSheet.Shapes("Label_info1").Visible = True
ActiveSheet.Shapes("Bretagne").Fill.ForeColor.RGB = RGB(0, 255, 0) 'Couleur de fond vert
End If
End Sub
Private Sub Image2_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
If X < 10 Or X > Image2.Width - 10 Or Y < 10 Or Y > Image2.Height - 10 Then
ActiveSheet.Shapes("Basse-Normandie").Fill.ForeColor.RGB = RGB(255, 255, 255) 'Couleur de fond blanc
ActiveSheet.Shapes("Label2").Fill.ForeColor.RGB = RGB(255, 255, 0) 'Couleur de fond jaune
ActiveSheet.Shapes("Label2").Visible = False
Else
ActiveSheet.Shapes("Label2").Visible = True
ActiveSheet.Shapes("Basse-Normandie").Fill.ForeColor.RGB = RGB(0, 255, 0) 'Couleur de fond vert
End If
End Sub
Private Sub Image3_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
If X < 10 Or X > Image3.Width - 10 Or Y < 10 Or Y > Image3.Height - 10 Then
ActiveSheet.Shapes("Pays-de-Loire").Fill.ForeColor.RGB = RGB(255, 255, 255) 'Couleur de fond blanc
ActiveSheet.Shapes("Label3").Fill.ForeColor.RGB = RGB(255, 255, 0) 'Couleur de fond jaune
ActiveSheet.Shapes("Label3").Visible = False
Else
ActiveSheet.Shapes("Label3").Visible = True
ActiveSheet.Shapes("Pays-de-Loire").Fill.ForeColor.RGB = RGB(0, 255, 0) 'Couleur de fond vert
End If
End Sub
Private Sub Image1_Click()
razShapes
Sheets("bretagne").Select
End Sub
Private Sub Image2_Click()
razShapes
Sheets("Basse-normandie").Select
End Sub
Private Sub Image3_Click()
razShapes
Sheets("pays-de-loire").Select
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
razShapes
End Sub
Sub razShapes()
For Each s In ActiveSheet.Shapes
s.Fill.ForeColor.RGB = RGB(255, 255, 255)
Next s
End Sub |
Partager