Probelms with Personal.xlsm and xml

[Mebs]

Can anyone help me here. I created a personal.xlsm workbook with 13 modules each containing vba code(marcos).

Then I used Custom UI editor for microsoft to add some xml to this workbook. The xml code simply add a new custom tab, which has custom groups and custom buttoms to run the above macro's.

If I open excel 2007 then everything works as it should. That is, the custom tabs, groups and buttons appears and the macros work.

Now when I open any of my existing workbooks this custom tab with the groups and buttons are not there.

I have tried all sorts of different things - deleted it all and created it all again, renamed workbook from xlsm to xlsb,etc. Still no joy.

Any ideas?

 

[xenou]

You can put your ribbon customizations in an Addin (.xlam) - that seems to work best. If you never used addins, just check around for a site that will explain the basics to you. I've been using an xlam to create a custom tab for Excel and so far so good.

Ron Debruin has some good ideas on this as well.
Lots of ribbon instruction here:
http://www.rondebruin.nl/ribbon.htm
An interesting alternative for your favorite macros here:
http://www.rondebruin.nl/qat.htm

 

[Mebs]

Thanks xenou, I have being following the instructions from Ron Debruin website. I carefully followed the instructions but I think that I have issue with or don't quite understand AddIn's.

Any site youcan suggest would be appreciated.

 

[xenou]

Addins aren't really very complicated per se. For starters though use a very simple one to test with:

• create a single workbook, with a single custom tab in it, and a single macro for it.
• Save the workbook as an addin (you can pick this in the save as type dropdown).
• Excel will probably "want" to save it in a user folder. That's fine. Addins can also go in a folder in program files in which case it would be available to all users.
• After doing this, you have to "install" the addin from your Excel options. Instructions are here:http://peltiertech.com/WordPress/installing-an-add-in-in-excel-2007/
• Hopefully it works. Now add the rest of your ribbon customizations.

 

[Mebs]

Dear xenou,

Thanks for the instructions, followed it specially the Add-in bit including in the link and it worked.

Any workbook I open the customised ribbon and macro's work.

Thanks for helping out.