Troque por esta:
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Target.Count > 1 Then
Application.EnableEvents = True
Exit Sub
End If
If Target.Column = 8 Then
Select Case Target.Value
Case "Lançar"
Call MacroLançar
Case "Deletar"
Call MacroDeletar
End Select
End If
Application.EnableEvents = True
End Sub
Existem mil maneiras de preparar Neston. Invente a sua!
http://www.youtube.com/ExpressoExcel
Postado : 05/08/2016 9:20 am