I have multiple userforms and controlling multiple worksheets. On open the workbook hides excel and opens up the userforms. Under one of my userforms the print preview selection works perfectly, but when trying to print the other forms off the other userform the print preview tab is completely greyed out so the only thing I can do from the preview screen is "X" out.

The code for hiding excel on open is
Please Login or Register  to view this content.
The printpreview command that works is
Please Login or Register  to view this content.
The print preview command that is all greyed out
Please Login or Register  to view this content.
I can get it to work fine if I don't hide the application, but I need excel to be transparent to the users to prevent corruption to the database. I can't see any difference in the code itself. I've tried to completely unprotects all the sheets from excel instead of through VBA with no success. Once the application hides the last command results in a preview window without no selectable options within the ribbon.

I can print with a printout command, but I need to be able to select a printer in case the office default printer is down and the easily way for me to achieve this is through the print preview screen. HELP!