Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-27-2019, 11:03 AM
inlanoche inlanoche is offline Change the ribbon on the fly? Windows 10 Change the ribbon on the fly? Office 2016
Novice
Change the ribbon on the fly?
 
Join Date: Apr 2019
Posts: 14
inlanoche is on a distinguished road
Default Change the ribbon on the fly?


Is it possible to change the ribbon (text, such as thee name of a group) with VBA?

would make visualizing a few things we are doing easier. Hoping...
Reply With Quote
  #2  
Old 05-27-2019, 02:46 PM
gmaxey gmaxey is online now Change the ribbon on the fly? Windows 10 Change the ribbon on the fly? Office 2016
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,421
gmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the rough
Default

Yes. You would use the dynamic attribute getLabel for the group in the ribbonXML and the VBA callback Sub GetLabel(control as iRibbonControl, ByRef returnedVal)
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote
  #3  
Old 05-28-2019, 06:14 AM
inlanoche inlanoche is offline Change the ribbon on the fly? Windows 10 Change the ribbon on the fly? Office 2016
Novice
Change the ribbon on the fly?
 
Join Date: Apr 2019
Posts: 14
inlanoche is on a distinguished road
Default

Interesting, I'll look into this more. The preliminary stuff I read points mainly to XML, and I was trying to stay strictly with VBA. Thanks for the pointer. On this note (stretching for greatness... ) is it possible to change the icon?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change the ribbon on the fly? too many clicks with ribbon - ribbon content disappears Rewster Word 2 05-12-2017 08:19 AM
How to import the customized ribbon to Word without overwriting the existing Ribbon? SharonSh Word VBA 0 09-26-2013 11:47 PM
Excel 2010 Ribbon look like 2007's Ribbon esotop Excel 0 03-22-2011 07:05 PM
Excel 2007 : change the ribbon (add a personal tab) webannik Excel 1 02-14-2011 05:13 AM
Office 2007 Ribbon Change Cannot Reverse Russ Office 0 04-29-2010 01:59 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:50 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft