Advertisement
Guest User

Untitled

a guest
Apr 19th, 2014
41
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.22 KB | None | 0 0
  1. Private Sub Worksheet_Change(ByVal Target As Range)
  2. If Target.Value = "b" And _
  3. Target.Column = 2 And _
  4. Cells(Target.Row, 1) <> "" Then
  5. Workbooks.Open ("b" & Cells(Target.Row, 1) & ".xlt")
  6. End If
  7. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement