PDA

View Full Version : Solved: Print Preview - Detect



Philcjr
02-12-2010, 11:07 AM
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?

Philcjr
02-16-2010, 12:42 PM
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?

'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