RE:VALIDAR EL INSERTAR UNA IMAGEN
Mira, sigue igual ya le cambie
Private Sub Worksheet_Change(ByVal Target As Range)
ActiveSheet.Unprotect
If Not Target.Address = "A1" Then Exit Sub
Dim De_donde As Integer, Foto As Object, _
Arriba As Double, Izquierda As Double, Ancho As Double, Alto As Double
Application.ScreenUpdating = False
On Error Resume Next
Me.Shapes("1").Delete
De_donde = "C:\FIRMAS\" & [A1] & ".jpeg"
If Dir(De_donde) = "" Then Exit Sub
Set Foto = Me.Pictures.Insert(De_donde)
With Me.Range("A35:A37")
Arriba = .Top
Izquierda = .Left
Ancho = .Offset(0, .Columns.Count).Left - .Left
Alto = .Offset(.Rows.Count, 0).Top - .Top
End With
With Foto
.Name = "1"
.Top = Arriba
.Left = Izquierda
.Width = Ancho
.Height = Alto
End With
Set Foto = Nothing
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub
Y no se que hacer, no existira alguna otra forma