Printing a non visible sheet via xldialogprint

A little background. I have setup a workbood which will be used by a lot of people in my company. One of the sheets, which will be the only visible sheet to the user, is just an input form. The other sheet is a "print layout" that is what I want to print. I have written some error checking into the Workbook_BeforePrint and part of that is as follows. Here's the problem. I am able to print just my print layout by unhiding the sheet, changing focus to it, printing, rehiding and then exiting the Workbook_BeforePrint. This works great and solves 99% of my problems. However, what I would like to be able to do is have the "print layout" print without it becoming visible first. If possible I don't want the users to even know that the print layout sheet exists. The reason for this is that we have had some problems with users properly filling out the previous version of this form in the past, and this will help eliminate that problem. I would like to stay away from the PrintOut function as I want the user to still have all the same functionality they are used to, i.e. number of copies, selection of desired printer, etc. Any help, even if just to tell me that this is impossible which I am quickly coming to believe, would be appreciated. Thanks in advance.
I have put three version of the code I have tried below.
Section 1.
This does everything I want, except it unhides the form first.
Section 2.
This also works, but only on the current sheet. Bad juju.
Section 3.
This also only prints the current sheet.
Section 4.
Again, in the immediate window it will set the active sheet to "PrintForm" just before the xldialogprint is brought up, but then prints only the active sheet.
Section 5.
Again, in the immediate window it will set the active sheet to "PrintForm" just before the xldialogprint is brought up, but then prints only the active sheet.

Please Login or Register  to view this content.

Bump, still hoping someone can help me.