When I worksheet is selected I want to hide the ribbon but show the ribbon tabs to allow the user to still access the ribbon functions.
Also when another file is selected I want the Workbook_Deactivate to check if the Ribbon is visible and if not to make it visible again.
I can find code to hide the ribbon and ribbon tabs but nothing to leave the ribbon tabs and to also check whether it's currently visible or not.
TIA
Also when another file is selected I want the Workbook_Deactivate to check if the Ribbon is visible and if not to make it visible again.
I can find code to hide the ribbon and ribbon tabs but nothing to leave the ribbon tabs and to also check whether it's currently visible or not.
TIA