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 offline 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,429
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



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 04:50 PM.


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