How to Add Custom Tab or Ribbon using VBA

[xlstime]

Dear Masters,

I have search and not able to understand "How to Add Custom Tab or Ribbon using VBA".

http://www.thespreadsheetguru.com/blog/step-by-step-instructions-create-first-excel-ribbon-vba-addin
http://www.contextures.com/excelribbonaddcustomtab.html

Can anyone guide me to make my first Custom Tab or ribbon using VBA.

 

[NARAYANK991]

Hi ,

Can you see if this helps :

http://www.rondebruin.nl/win/s2/win001.htm

Narayan

 

[xlstime]

Thanks Mate!..

But Is there any way to do this thru VBA only

Hi ,

Can you see if this helps :

http://www.rondebruin.nl/win/s2/win001.htm

Narayan

 

[NARAYANK991]

Hi ,

No. Or at least , you would have to write a complete XML editor to read the XML file in which Excel stores the Ribbon configuration , modify it using VBA , and then write it back to the file.

All of the above has already been done for you in the CustomUI editor.

All you need to do is to use it to make your desired changes to the Ribbon.

Narayan

 

[xlstime]

Thanks a ton Narayan,

Hi ,

No. Or at least , you would have to write a complete XML editor to read the XML file in which Excel stores the Ribbon configuration , modify it using VBA , and then write it back to the file.

All of the above has already been done for you in the CustomUI editor.

All you need to do is to use it to make your desired changes to the Ribbon.

Narayan