Is there a way to detect when a user goes into PrintPreview?
I have some code in the "Workbook_BeforePrint" sub and I want to jump over it. Specifically, I want to jump over:
Application.Dialogs(xlDialogPrint).Show Arg12:=2
Any ideas?
Is there a way to detect when a user goes into PrintPreview?
I have some code in the "Workbook_BeforePrint" sub and I want to jump over it. Specifically, I want to jump over:
Application.Dialogs(xlDialogPrint).Show Arg12:=2
Any ideas?
Does anyone have any suggestions??
After many hours of searching and searching I have found that it is not possible to detect whether or not "Print" or "PrintPreview" tiggeres the "Workbook_BeforePrint".
Short of disabling the Print Preview... any other ways to approach this?
[vba]
'Turn off Print Preview from Standard Toolbar
Dim CBControl As Office.CommandBarControl
For Each CBControl In Application.CommandBars.FindControls(ID:=109)
CBControl.Enabled = False
Next CBControl
[/vba]