When set to route, route with on open worksheet...not the hidden o
 

Hello,
I have a workbook that has a few hidden worksheets that contain data. The
main worksheet is a form that is eventually routed to other people. Is is
possible to create a macro that will route the worksheet (form) and only the
active sheet...therefore deleting or emilinating the other sheets? This
would definitely help to reduce the file size.

Thanks in advance.
Mike