excel 2010 crashes when printing and print.preview Macro

Excel Crashes When use this Macro for print preview and printer window ,so I searched alot on Google to see how to solve this problem ,but i fail. Here is the code i use to PrintPreview :
VB:

Please Login or Register  to view this content.

So How to solve these Problem i use Excel 2010 32 bit with Win7 32 bit >>??????

Macro Worked fine for me on Win7 64 bit. Does print preview manually crash as well? I would look at possibly reinstalling printer driver. Without being able to replicate your problem, its hard to offer a solution