code Help - Routing Recipients

  • Thread starter Thread starter Neil
  • Start date Start date
N

Neil

Hi there, im looking for some code which i can attach to a button on my
spreadsheet,

basicaly, i want eht button to do this, in this order,

save the spreadsheet
send to the next recipient on the routing list
then close the app


Any help is greatly apreciated,

thanks,
neil
 
got it,

Private Sub CommandButton1_Click()

ActiveWorkbook.Save 'save sheet
ActiveWorkbook.Route 'send to next recipient on route list
ActiveWorkbook.Save 'save again, to sto annoying dialogue
ActiveWorkbook.Close 'close workbook

End Sub


neil
 
Back
Top