very cool. Can it be built so that only certain values entered into the A1
cell will point it to the other worksheet?
ew

"Jim Thomlinson" wrote:

Try this in the code for sheet 1. Right Click the Tab. View Code. Paste this...

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then Sheets("Sheet2").Select
End Sub

Changes made to Cell A1 take you to sheet 2...

HTH

"ew" wrote:

I need to build a macro that will take the user to another worksheet when a
specific value is entered into a cell. Any suggestions?
Thanks,
ew