|
JBB9629 发表于 2013-5-6 12:00
对不起忘了传附件
这是在在2003中可以运行通过的附件 - Private Sub Worksheet_Change(ByVal Target As Range)
- If Target.Address = "$C$8" Then
- Me.Pictures.Delete
- With Range("E8").MergeArea
- Me.Shapes.AddPicture Filename:=ThisWorkbook.Path & "\Photos" & Range("C8") & ".PNG", _
- LinkToFile:=True, SaveWithDocument:=True, _
- Left:=.Left, Top:=.Top, Width:=.Width, Height:=.Height
- End With
- End If
- End Sub
复制代码 |
|