ExcelBanter - Using SendKeys to ‘activate’ a tab on 2007 Ribbon

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Using SendKeys to ‘activate’ a tab on 2007 Ribbon (https://www.excelbanter.com/excel-programming/411211-using-sendkeys-%91activate%92-tab-2007-ribbon.html)

KobusD[_2_]

Using SendKeys to ‘activate’ a tab on 2007 Ribbon

I have been using SendKeys to make a custom tab the ‘active tab’. Is
there a more elegant way of activating a tab on the 2007 Ribbon using
VBA?

All times are GMT +1. The time now is 10:04 AM.