Print Preview Hidden Sheets from a UserForm

**edilly** · 10-16-2013, 11:25 AM

I'm using userforms as a method to input data and create forms. So far I have Hidden Excel and opened the main Userform on open. I have a total of 5 userforms that all create different forms that I need available for print. On one of the userforms I have a command button to print preview the appropriate worksheets. I need help with the code to show the sheets, execute the preview/print, hide the sheets. All of this without ever displaying the workbook to the user if possible. my current Print preview command is

Please Login or Register  to view this content.

**edilly** · 10-24-2013, 11:46 AM

Problem Solved. Thanks

**arlu1201** · 10-25-2013, 02:21 AM

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.