closing Print Preview mode

[chander]

hi .. its some wat related to my old question .. can one tell how i can close the print preview mode through code .. i meant when workbook is in print preview mode i want to come back in normal mode by running my code .. not by click on Close Button . there is Window property to get in normal mode but that works when u r in PageBreak preview mode .. not in print preview mode.. i want to get to normal view from Print previewview mode in my program.

 

[Jaamie]

Preview Mode

I believe that once you enter Preview Mode, Excel is waiting for an answer and won't give up control until it gets one.
Is there some other way to accomplish whatever it is that you are using print preview for? Since you don't want to have the user click "close".

Jaamie