How to add a Custom menu TAB for Seperate work book

[selvamariappan]

Dear all,

Can any one help me on this,

I need to add a own menu tab and its option or button for seperate work book which should not be visible in other workbook.

FYI : I am using excel 2010 and the excel file is macro enabled file(.xlsm)

Please help me on this.Its urgent.

Regards,
Selva.C

 

[selvamariappan]

Yeah thats right, Using Custom UI Editor For Microsoft Office only i have added the menu.

I don't know where to attach my sample file in this thread.

 

[RoryA]

if you added a 2010 specific customui then it won't work.
you can't attach files in this forum, but you could upload it to a site like box.net or skydrive.

 

[selvamariappan]

Oh then what to do get this menu in 2007 ,

Is there any other way to this process.

I need that menu when I open it in 2007 and also in 2010.

Please assist.

 

[RoryA]

YOu need to add a 2007 part in the CustomUI Editor, not a 2010 one.

 

[selvamariappan]

Yeah that's right Rory!! Since i am new to customui editor.

I have learnt a lot from you . Thanks for everything

I have used the following solution.

1: Open Book1.xlsm in the Custom UI Editor
2: Right click on the File name in the Custom UI Editor or use the Insert menu
3: Choose "Office 2007 Custom UI Part" to create the customUI.xml file
4: Paste the same 2010 code here and change the year 2009 to 2006.

And finally it works fine for both 2010 and 2007.

 

[RoryA]

Glad to hear it.