Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-27-2014, 10:28 AM
Larry Sulky Larry Sulky is offline VBA to modify ribbon icon on the fly Windows 7 64bit VBA to modify ribbon icon on the fly Office 2010 64bit
Novice
VBA to modify ribbon icon on the fly
 
Join Date: Mar 2014
Posts: 14
Larry Sulky is on a distinguished road
Question VBA to modify ribbon icon on the fly

In Word 2010, I have to support a Word 2003 toolbar and macro set that does the following: The user can select any of a handful of custom pulldown menus, each of which has a dozen or so buttons. Each button within a given menu calls the same macro, which detects the text name of the button and behaves accordingly. In addition, the behaviour is also affected by whether the visual icon for the button was a "ticked" tick-box, or an "unticked" tick-box. (There is also an "uninitialised" tick-box, but that's a minor issue). Finally, one of the behaviours of the macro is to toggle the icon between its "ticked" and "unticked" forms.

Example:



The user pulls down Menu Omega, and notes that in that menu, Button Alpha is in "unticked" state. The user clicks Button Alpha. This triggers macro XYZ, which:

1. Detects that it was Button Alpha that was clicked, and that the icon is currently the one associated with "unticked" state (by checking the icon's numeric VBA ID).
2. Executes a series of commands appropriate to the intent of "turning on" state Alpha.
3. Changes the icon to the one associated with "ticked" state.

Now the user clicks Button Alpha again. This triggers macro XYZ again, this time with the result that the actions are appropriate to the intent of "turning off" state Alpha, and changing the icon back to "unticked" state.

My problems in Word 2010:
* I'm having a heck of a time creating menus within which to put the buttons.
* I can't figure out how to access the text names or the icon IDs. The properties just aren't the same as in Word 2003.
* I can't figure out how to change the icon IDs on the fly. Again, properties that work fine in Word 2003 aren't there in Word 2010.

Any ideas out there? For the moment, I'm simply keeping an old laptop that has Word 2003 on it, doing the development updates there, then bringing it over into Word 2010, where it works fine. But that's not a good long-term strategy.

TIA....

ON EDIT: I forgot to mention that I wrote the 2003 VBA code.

Last edited by Larry Sulky; 03-27-2014 at 10:32 AM. Reason: more info
Reply With Quote
  #2  
Old 04-03-2014, 07:46 AM
Larry Sulky Larry Sulky is offline VBA to modify ribbon icon on the fly Windows 7 64bit VBA to modify ribbon icon on the fly Office 2010 64bit
Novice
VBA to modify ribbon icon on the fly
 
Join Date: Mar 2014
Posts: 14
Larry Sulky is on a distinguished road
Default

Folks, I haven't heard anything on this. Does anybody have any ideas? If not code, maybe a great book or website or tool that I haven't encountered that could help me work toward a solution?
Reply With Quote
Reply

Tags
menu modify

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to import the customized ribbon to Word without overwriting the existing Ribbon? SharonSh Word VBA 0 09-26-2013 11:47 PM
Ribbon's Icon disappear sometime agupta Office 0 09-20-2013 12:30 AM
sort & filter icon not available or icon not highlighted survivo01 Excel 1 08-08-2011 03:41 AM
VBA to modify ribbon icon on the fly Display as icon: default icon for pdf's. njegbers Word 1 04-08-2011 06:07 PM
Excel 2010 Ribbon look like 2007's Ribbon esotop Excel 0 03-22-2011 07:05 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:03 PM.


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