VBA that will open another workbook when cell value changes

[cdexcel]

I am trying to write a vba program will open another worbook from my "My Documents" when any cell in column in column Q is changed to "In Progress". This is what I have, but I cannot get the range to work.

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = "$Q" Then

If Range(Cells("Q")).Value = "In Progress" Then

Workbooks.Open "C:\Documents and Settings\"

End If

End If

End Sub

[Norie]

Try this.

Please Login or Register  to view this content.

You should add code tags to your post.

[cdexcel]

Great! It worked, thanks to Norie.

What should I add to the program if I want to also look at column T to see if the corresponding cell value is "Scheduled" before opening the document. But if colmun T is blank, end the program without opening.

[Norie]

Perhaps this.

Please Login or Register  to view this content.

[cdexcel]

Thanks for the help Norie; it worked perfect.

[cdexcel]

I am fairly new at VBA programming, so there is one more thing that I am trying to figure out. Adding to the above code, I want the code to open and save the workbook to the location which is specified by a hyperlink on column B of the original worksheet.