Dim W As Single, H As Single, pos As Integer
Private Sub Image1_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
On Error Resume Next
ActiveSheet.Shapes("chem").Visible = 0
W = ActiveSheet.Shapes("image1").Width - 8
H = ActiveSheet.Shapes("image1").Height - 8
If Y >= 8 And Y <= H And X >= 8 And X <= W Then
ActiveSheet.Shapes("chem").Visible = 1
pos = Application.Match(X, Array(0, 107, 214, 321, 428, 535, 642, 749, 856), 1)
ActiveSheet.Shapes("chem").TextFrame.Characters.Text = WorksheetFunction.Index([lestitres], pos, 1)
End If
End Sub
Sub Image1_Click()
Application.Goto Sheets("Classeur" & pos).[A1]
End Sub