Skip to Content
0
Former Member
Oct 30, 2012 at 05:39 PM

Before_Send Issue

43 Views

Hello Experts,

I would like to add a Before_Send function to my input template in excel. I cannot get the function to call in the VBA. I do currently have a Before_Refresh and After_Refresh that work fine. This function should run when I hit the Save Data button on the ribbon correct? Below is my code, I put a simple test in to see if it is working, which it is not.

Function BEFORE_SEND(Argument As String)

MsgBox Argument

BEFORE_SEND = True

Workesheets("Sheet1").Cells(7, 2).Value = "Test"

End Function

Any advice would be helpful.

Thanks,

Sean