ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Activate ribbon tab via VBA (https://www.excelbanter.com/excel-programming/399684-activate-ribbon-tab-via-vba.html)

DRA

Activate ribbon tab via VBA
 
I added a general usage tab to the ribbon (replaced 2 commandbars from
XL2000). For some workbooks, I also add a unique tab to the ribbon for its
macros. I want to activate my general usage tab when I close the workbooks.
Is this possible? How?
--
Thanks,
Don

Jon Peltier

Activate ribbon tab via VBA
 
As far as I know, it is not possible to activate a ribbon tab using VBA.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"DRA" wrote in message
...
I added a general usage tab to the ribbon (replaced 2 commandbars from
XL2000). For some workbooks, I also add a unique tab to the ribbon for
its
macros. I want to activate my general usage tab when I close the
workbooks.
Is this possible? How?
--
Thanks,
Don





All times are GMT +1. The time now is 04:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com