#1
|
|||
|
|||
Manipulating the ribbon
When I try to record a macro in which I switch on (or off) any tab in the ribbon, nothing is recorded.
Is it possible to manipulate the ribbon with VBA? I'm using a Dutch version of Word 2013. Last edited by vanLonden; 12-21-2017 at 03:15 AM. Reason: Forgot something. |
#2
|
||||
|
||||
It is certainly not possible with the macro recorder, and while you could create a macro to edit the ribbon, as you had to ask, you would undoubtedly find it simpler to edit the XML code - see http://gregmaxey.mvps.org/word_tip_p...bbon_main.html
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#3
|
|||
|
|||
I'm sorry but that is no solution for me. Would it be possible with VBA to make a certain tab invisible?
|
#4
|
||||
|
||||
If you mean can I create a macro in Word that will simply hide a tab on the default ribbon, then the answer to that is no.
You can do it with a document or template, but as that also requires manipulation of the ribbon XML code to provide the hooks for VBA to be able to hide the tab, it is probably simpler all round just to edit the ribbon itself - hence my suggestion. If you want to dig deeper see https://www.rondebruin.nl/win/s2/win012.htm (although for Excel the principles are the same) and in particular download https://filedb.experts-exchange.com/...t-in-Tabs.xlsm, but somehow I don't think these are what you had in mind.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#5
|
|||
|
|||
Txs anyway.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Manipulating Data in Cells | Stockturn | Word Tables | 1 | 09-11-2017 04:45 AM |
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 |
Manipulating checkboxes in XML | Ivo | Word | 0 | 12-06-2005 09:04 AM |