Disable Print Preview in dialogue box

[novice1]

When I call the print dialogue box via Application.Dialogs(xlDialogPrint).Show, clicking the print preview crashes my workbook. I google for a solution and came across this code...

Application.Dialogs(xlDialogPrint).Show (preview = False)

but it errors highlighting preview. I'm kindly looking for assistance for a solution this problem. Thanks

I'm currently using excel 2007, but I have other computers that have excel 2000 - 2010.

 

[tweedle]

The possible solution you found was relative to XL2000.
I see the same issue in 2007.

retval = Application.Dialogs(xlDialogPrint).Show(Arg2:=1, Arg3:=100, Arg4:=5, Arg6:=False)

ARG6 should disable the Preview, but mine still works just fine.