I have a VB reporting application that works correctly in Excel 2010, but not in Excel 2016 or the versions between.
The Activesheet.PrintPreview is called from a macro. It is displayed correctly but scrolling and next page / previous page are not working.
The report was being opened up in compatibality mode. I thought that this might be causing the problem. Since posting the first question, I have converted the file from .XLS to .XLSM format. The report is no longer opening in compatibility mode. However the problem is still there. I also checked for hidden items and there aren't any.
When print preview is being displayed. I can click next page and it see that I clicked it because the previous page is enabled. The page does not change until I click on the report. The scrollbar behaves the same way.
Macro
Public Sub sbPreviewQLSReport(spdfFile As String, sODInfo As String)
'Procedure name is changed from sbPreviewReport so that all new qls releases
'that 2.10 and above wil call the new procedure
gsPDFFileName = spdfFile
gsOSInfo = sODInfo
Call SbSetupWindowsDirectory
'Keep app minimised while it is being configured.
mlWindowState = Application.WindowState
Application.WindowState = xlMaximized
'Prevent screen changes to speed up report processing.
Application.ScreenUpdating = False
Application.DisplayAlerts = False
'Setup application globals.
Call sbSetWorkSheetVariableNames
ActiveSheet.PrintPreview
ThisWorkbook.Windows(1).Visible = False
'Show the user the preview.
Application.ScreenUpdating = True
End Sub