Print PreView

[zplugger]

Using this code to open Print Preview,when I close and return to sheet the cursor will not work in any cell? Only have
problem if I print preview.

Please Login or Register  to view this content.

[zplugger]

Think found problem
On workbook open I use

Please Login or Register  to view this content.

,on the print preview button I was using

Please Login or Register  to view this content.

so I
could close the window.Can I just hide the ribbon with code ?

[LJMetzger]

According to Ron de Bruin, you can toggle the Ribbon in Excel 2013 with:

Please Login or Register  to view this content.

He also has examples for displaying and hiding the ribbon. See http://www.rondebruin.nl/win/s2/win003.htm

Lewis

[zplugger]

Thanks for the info LJMetzger