On Aug 15, 11:12*am, Reggie wrote:
Hi,

I'm using the Application WorkbookBeforePrint Event to hijack the normal
Print and Print Preview functions in Excel 2003 & display some customised
options. *How do I determine whether the user clicked the Print button or the
Print Preview button?

thanks,

As far as I know you are unable to. There are at least a couple of
workarounds though...

1) Put a print button on your worksheet and control everything from
there. (by far the simplest, just need to educate the users...)
2) Manipulate the toolbar and replace the standard print and print
preview buttons with your own code, you would then need to reset them
upon closing your workbook.

James