Problem with Macro printing code

**Usethaschwarz** · 06-25-2012, 08:10 AM

I have a vba code for a form needing to print out only some specific information. This code is a "before print" code and will change the cell content's font to the background color so the information will not appear. Everything seems to work perfectly except, for some reason, the print screen does not appear when I click print and the form prints directly to my default printer. Since many people will be using/printing this form from different computers, I need this print screen to appear so they may choose which printer to print to. Strangely enough, I am able to get to this print screen when I go to print preview first, but not when I select print directly. I have copied my current code below for editing. Since I was able to find this code online, and I am very bad at vba programming, I was hoping someone could make edits in the code for me. Thanks!

Please Login or Register  to view this content.

**JapanDave** · 06-25-2012, 08:18 AM

Have you tried this?

Please Login or Register  to view this content.

**Usethaschwarz** · 06-25-2012, 08:27 AM

Would that replace the Sheet2.PrintOut command? Also, I was hoping there would be a way for the print screen to actually appear when anyone selects print (so they don't need to go to print preview first). Thanks for your help!

**JapanDave** · 06-25-2012, 08:49 AM

In that case use this.

Please Login or Register  to view this content.

**Usethaschwarz** · 06-25-2012, 08:56 AM

Hmm okay, the print preview command that you posted brings up print preview even when you just want to directly print it. And the dialogs print command brings up the print screen even when you click print preview, which is a bit confusing. Is there any way to bring up the print screen when someone selects print but also allows someone to select print preview without the print screen popping up first?