• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to create a Custom Menu or Ribbon in Excel with VBA and install

I

inddon

Member
Hello there,


I am a new bee in VBA-Excel and planning to make a small custom application in MS Excel using VBA. This small application would be installed installed in desktops.


I would like to make a custom menu bar for version prior to 2007 and a Ribbon for version >= 2007. In this Menu bar/Ribbon, I would like to include some items.


My 2 questions are as follows:

1. How can I make the custom bar and ribbon?

2. I would like to create a .dll or library, so that when I install my custom application on the desktop it should automatically create the custom bar or ribbon in MS Excel. How can I achieve it?


Could you experts out there help me out, learn more about Excel and VBA?


Thank you so much


Regards

Don
 
Hi Don ,


You will find a lot of help in these links :


1. http://www.rondebruin.nl/ribbon.htm


2. http://dutchgemini.wordpress.com/2011/01/20/custom-excel-2007-ribbon-and-vba/


3. http://chandoo.org/wp/2012/02/27/how-to-add-your-own-macros-to-excel-ribbon/


4. http://www.andypope.info/vba/ribboneditor.htm


Narayan
 
Hi Narayan,


Thanks you for your advice. I will check the links and try out. Shall keep you guys updated


Regards

Don
 
You must log in or register to reply here.
Back
Top