Hyperlinking Code for an image.

[gerryger]

I have a active X image that I would like to add VB code to. The image should hyperlink to a sheet in my workbook. The cell above it contains the criteria (cell e3) it contains the 12 months in a drop-down list. (Jan, Feb, Mar, etc) The sheet names are the same. Obviously the criteria (months will change) looking for some code to make that work. Thanks

 

[My Aswer Is This]

Try this:
Assuming you enter a proper sheet name in range("E3")

Sub Select_Sheet()
On Error GoTo M
Sheets(Range("E3").Value).Activate
Exit Sub
M:
MsgBox "No such sheet exist"
End Sub