AFAIK, there's no way to detect the difference between Print and Print
Preview.

However, you can trap the Print Preview command with something like:

CommandBars(1).Controls("File").Controls("Print Preview").OnAction:= _
"MyMacro"

and

Commandbars("Standard").FindControl(id:=109).OnAct ion = "MyMacro"

In article ,
"Simon Shaw" <simonATsimonstoolsDOTcom wrote:

what if the user was performing a print preview... how do I tell the
difference?