Name

workbook.RoutingSlip

Synopsis

Returns the workbook’s RoutingSlip object. Use HasRoutingSlip to create a routing slip and to determine if a workbook has a routing slip. The following code creates a routing slip and routes a workbook:

ThisWorkbook.HasRoutingSlip = True
With ThisWorkbook.RoutingSlip
  .Recipients = Array("Beige Bond", "Jeff Webb")
  .Message = "For your review"
  .Subject = "New budget"
  .Delivery = xlOneAfterAnother
End With
ThisWorkbook.Route

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial