Automatically open another worksheet. . .-Is this possible?

[bokonon]

I would like to have certain cells in my worksheet automatically open another worksheet when they are populated. In other words, if you enter an "X" in one cell, the other sheet automatically opens to a related cell that you have to populate to continue. Is this possible?

[jetted]

Hi

Not sure of your retirement. However if and x is being input in cell a1
then file C:\amy1.xls will open. This should be amended to your specification.

Private Sub Worksheet_Change(ByVal Target As Range)
'if and x is being input in cell a1
'then file C:\amy1.xls will open
check_valu = Range("a1").Value
If check_valu = "x" Or check_valu = "X" Then
ChDir "C:\"
Workbooks.Open Filename:="C:\amy1.xls"
End If
End Sub