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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.