PDA

View Full Version : VBA Printing Code Problem



Usethaschwar
08-16-2012, 04:40 AM
I have a form on excel that many people on different computers will be filling out. I have written a VBA printing code so that the columns that show cost information will automatically be blanked out when someone wants to print.

I've received 3 different codes to try:

Application.Dialogs(xlDialogPrint).Show - Only the print function works normally, not quick print or print preview. The print dialog box appears when you select any of the three print options.

Sheet2.PrintOut - Only the quick print function works normally. This will print to the default printer without the print dialog box appearing when you select any of the three print options.

ActiveWindow.ActiveSheet.PrintPreview - Only the print preview function works normally. Print preview appears when you select any of the three print options.

I'm hoping to find a code that allows all 3 printing functions to work normally. Any new suggestions? Thanks for your help!