Using attached sheet code in Excel 2016 which is not working to Hide main Bars please look into this issue.