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