Macro to print the current worksheet WITHOUT having Print Preview

Can anyone advise if it is possible and what the macro would be if I simply wanted to print out the current worksheet without having any preview window displayed which requires the 'Print' / 'Cancel Print' options presented to you.

I am running Excel 2007 in Windows XP and use a Canon Pixma iP4950 printer

Sorry , that doesn't work ! If your 'Print Preview' box is ticked in the Printer Properties section , you get a Print Preview. Simple as that. Trick is for the macro to over-ride the ticked box somehow ! Don't know how.
Thanks anyway.

After days of trial and error , I believe that I have eventually come to fully understand the background to the situation. Contributors have helped but none had FULLY explained the scenario.
The conclusion that I have come to is as follows :

BOTH the Printer AND EXCEL have a PrintView facility.
In order for EXCEL to Print WITHOUT a Preview , the PRINTER Preview setting must be switched OFF.
So ,
with PRINTER PREVIEW = OFF , macro ActiveSheet.PrintOut Preview:=False PRINTS WITH NO PREVIEW

with PRINTER PREVIEW = OFF , macro ActiveSheet.PrintOut Preview:=True PRINTS WITH EXCEL PREVIEW ON

with PRINTER PREVIEW = OFF , macro ActiveSheet.PrintOut PRINTS WITH NO PREVIEW

with PRINTER PREVIEW = ON , macro ActiveSheet.PrintOut PRINTS WITH NO EXCEL PREVIEW BUT WITH PRINTER PREVIEW

The problem with all this is that one would normally run a printer with the Preview ON - well I do anyway - and if you are running an Excel Worksheet which has a macro to operate with or without preview , you must remember to set the PRINTER to PREVIEW OFF before you use the worksheet.
As far as I can tell , Excel cannot switch off the PRINTER PREVIEW SETTING (which would be the ideal scenario) ..... unless someone can tell me otherwise !