Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 281
  • Last Modified:

Excel 2010 - Ribbon buttons

Dear Experts,

Can you please have a short look on the attached picture, it is my current ribbon with the macro buttons, but somehow I liked this more in before version of excels.

Because in the first blue marked area there are 8 macros, and I need to always go over with the mouse to ensure that the proper one will start. Relating the second blue marked area that is superfluous to be so wide just for a single macro.

Is there maybe a method to control this? That the first blue marked area should be bigger with seeing the button descriptions, and the second one could be the small icon.

thanks,

Ribbon.jpg
0
csehz
Asked:
csehz
1 Solution
 
regmigrantCommented:
It depends how the ribbon was customised in the first place but in general you can use XML to customise it. Search ribbon customisation in VBA help and it will provide a sample - which refers to button sizes and creating groups.

If it is generated by someone elses code then there's not much you can do without access to the source
0
 
csehzIT consultantAuthor Commented:
Thanks
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now