Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-21-2017, 03:14 AM
vanLonden vanLonden is offline Manipulating the ribbon Windows 7 32bit Manipulating the ribbon Office 2013
Novice
Manipulating the ribbon
 
Join Date: Oct 2016
Posts: 6
vanLonden is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 12-21-2017, 04:38 AM
gmayor's Avatar
gmayor gmayor is offline Manipulating the ribbon Windows 10 Manipulating the ribbon Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

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
Reply With Quote
  #3  
Old 12-21-2017, 05:07 AM
vanLonden vanLonden is offline Manipulating the ribbon Windows 7 32bit Manipulating the ribbon Office 2013
Novice
Manipulating the ribbon
 
Join Date: Oct 2016
Posts: 6
vanLonden is on a distinguished road
Default

I'm sorry but that is no solution for me. Would it be possible with VBA to make a certain tab invisible?
Reply With Quote
  #4  
Old 12-21-2017, 08:16 AM
gmayor's Avatar
gmayor gmayor is offline Manipulating the ribbon Windows 10 Manipulating the ribbon Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

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
Reply With Quote
  #5  
Old 01-09-2018, 03:14 AM
vanLonden vanLonden is offline Manipulating the ribbon Windows 7 32bit Manipulating the ribbon Office 2013
Novice
Manipulating the ribbon
 
Join Date: Oct 2016
Posts: 6
vanLonden is on a distinguished road
Default

Txs anyway.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Manipulating the ribbon Manipulating Data in Cells Stockturn Word Tables 1 09-11-2017 04:45 AM
Manipulating the ribbon 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:20 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