Hi all,
I know it's primarily a report question, but so many more eyes here. I am trying to disable the print preview ribbon from dropping down when I preview any report in A2010.
I have tried this calling this function option in 'Current', 'Activate', and 'Open', and whilst it works perfectly for forms, it just won't prevent the Preview Ribbon for reports!
option:
If Not CommandBars.GetPressedMso("MinimizeRibbon") Then
CommandBars.ExecuteMso "MinimizeRibbon"
End If
It is important that the report opens into Print Preview mode, as some users may wish to save a tree frog by not printing a large report...
Any clues anyone?
cheers
Pete