use picture as a button

A

ash

is it possible to have a picture as a button to take the
user to another page? (using a macro)?
 
M

Mark \(In Wales\)

Hello Ash

This won't turn your picture into a button, someone with more experience can
help you with that but below is what I generated with the macro recoreder.
HTH
Mark (InWales)

Sub Picture_Press()
' Picture_Press Macro recorded 14/09/04
'unprotect worksheet it doesn't appear to work if the worksheet is protected
ActiveSheet.Unprotect
Sheets("sheet1").Select
ActiveSheet.Shapes("Picture 1").Select
'Reprotect the worksheet before going to the next one to stop accidental
deletion
ActiveSheet.Protect
'show the user all the actions of keystrokes and workbook changes
Sheets("sheet2").Select
End Sub
 
Top