VBA Print preview in Excel 2007
I have come across the following using VBA in Excel 2007 which I cannot resolve.
I have a number of files that make extensive use of VBA and for many of them print preview is enabled, together with application.screenupdating set to false. In Excel 2000, 2002 and 2003 everything is fine and the preview appears together with controls to print, cancel etc.
In excel 2007 the following applies if screenupdating is false and preview is true the preview appears but the ribbon remains on that which applied when the macro was invoked. It is possible to exit using the esc key but not to print.
If anyone else has come across this problem I would be interested to hear if you have the same issues.