Forum Discussion
Solved
How to restore selected ribbon tab after report with a custom ribbon is closed?
We have a database which has two ribbons. A Switchboard ribbon with multiple tabs and a hidden PrintPreview ribbon used through report “Ribbon Name” property. The PrintPreview ribbon has startFromS...
after you the report is closed and after showing the Switchboard ribbon, you Activate which tab the closing report belongs, eg:
gobjRibbon.ActivateTab "tab2"
Hi Arnel_gp,
Thank you foryour help.
I tried to avoid modifying 300+ reports and extra coding, but looks like Microsoft, as usual, did half cooked job this its beloved ribbon and left no chose for VBA and Office developers as to waste time on work arounds.