ExcelBanter - Select Tab on Ribbon at Run Time

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

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

- - Select Tab on Ribbon at Run Time (https://www.excelbanter.com/excel-programming/389120-select-tab-ribbon-run-time.html)

Kent

Select Tab on Ribbon at Run Time

Is there any way to select ("activate") a tab on the ribbon at run
time? I have a book titled "Excel 2007 VBA" that states the only way
to activate a tab is by using send keys but it does not provide an
example.

All times are GMT +1. The time now is 03:34 AM.