Macro to move between sheets

P

Pete JM

Hi,

I would like to have a macro that would look at a value in cell A5 and
then go to the Worksheet that has the same name.

For example if i typed Sheet 1 in cell A1 then clicked on the macro i
would automatically be taken to Sheet 1.

Is this possible?

Regards

Pete
 
D

Don Guillett

How about a fully automatic way. NO clicking necessary
Right click sheet tab>view code>insert this.
Now when you type sheet1 in cell a1 you will goto sheet1

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.address <> "$A$1" Then Exit Sub
Sheets(Target.Value).Select
End Sub
 
Top