Private Sub Worksheet_SelectionChange(ByVal Target As Range) '设置工作表单击事件
If Target.Column = 3 And Target <> "" Then '工作表第3列单击且单元格数据不为空时运行
Dim S As Shape
For Each S In ActiveSheet.Shapes
If S.Name = "P1" Then S.Delete
Next
ActiveSheet.Pictures.Insert(Target.Text & ".BMP").Select'插入BMP位图