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