Macro to open Print Preview & Print from Quick Access Toolbar

[fastcar]

Hi There,

I am trying to create a macro that when activated will perform the action exactly as if you click the little Quick Command Button at the top of excel that says "Print Preview and Print"

This is what I have tried to use but does not work as I would like.

Please Login or Register  to view this content.

[davesexcel]

Please Login or Register  to view this content.

or .print

[fastcar]

Perfect Thanks