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

 

[Domski]

Have a look here: http://www.rondebruin.nl/ribbon.htm

Dom

 

[selvamariappan]

Hi Thanks for your reply,

From that link I couldn't able to find out the method step 3

3: Open Book1.xlsm in the Custom UI Editor

Please tell how to open it thru Custom UI Editor i dont know where is it .Else i will tell more clearly about my need.

I have developed a macro code and i need to call it through some menu options that menu should be available in that work book alone,

Please assist on this

 

[Domski]

From the link:

If you want a easy way to insert RibbonX into a Excel 2007-2010 workbook, then I suggest you
download and install the new version of the Custom UI Editor here :
http://openxmldeveloper.org/archive/2006/05/26/CustomUIeditor.aspx

Dom

 

[selvamariappan]

Hi Dom,

Thanks for your time and help.

Is there any possiblity to show/hide our own menu tab for seperate workbook.

for me no permission to download and install any new s/w.

Please provide me how to hide my menu tab for other workbooks.

Thanks in advance.

 

[selvamariappan]

Hi Thanks for your reply.

See my need is that just to show a menu tab in a seperate work book.

when i open other .xlsm file that menu should not displayed.

for this please help me.

 

[Domski]

Assuming you have code in the workbook for adding and removing your custom menu item you would need to add Workbook level Activate and Deactivate event codes to run these. Then when you open the workbook or switch between it and other open workbooks the menu will show or hide.

For info on event code have a look here: http://www.cpearson.com/excel/Events.aspx

Dom

 

[selvamariappan]

Thanks for helping me till this time.

Its showing "Invalid procedure call or argument" error
Please have a look on my code.

My menu name is Nokia

Private Sub Workbook_Open()
Application.CommandBars("Worksheet Nokia").Visible = True
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.CommandBars("Worksheet Nokia").Visible = False
End Sub

even i tried this
Application.CommandBars("Nokia").Visible = True


Can you please help me to clear this issue.
and also one more thing
i have the sheets name as pen1,pen2,pen3

i need to display my menu on for the pen2.

Please assist on my code.

 

[Domski]

I'm on Excel 2003 at work so can't test your code but I've a feeling that won't work in 2010.

You're using Open and Close events whereas it should be either Workbook level Activate and Deactivate events for the whole workbook. For an individual sheet it's a bit more complicated. I think you would need to have the workbook level events with a check to see that the active sheet is and also worksheet level Activate and Deactivate events.

Dom

 

[selvamariappan]

Thanks for your help,

Please help me in the code,i couldn't able to hide a menu in workbook level

Kindly help me in code.

i need to show a menu for this workbook alone and hide it when the workbook closed it.

Please help me