How to add a Custom menu TAB for Seperate work book

[selvajan23]

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 alone 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

[Jan Karel Pieterse]

Check out this page:
http://www.rondebruin.nl/ribbon.htm

[selvajan23]

Hi ,

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.

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

Thanks in advance.

[Jan Karel Pieterse]

Ribbon customisations are workbook specific, except for add-ins. So if you have a "normal" xlsm file, all you have to do is add the RibbonX code, Excel handles the hiding and showing of your new tab.

[selvajan23]

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.

[Jan Karel Pieterse]

The web page I pointed you to explains how to do exactly that.
I suggest you to go to that page and read it carefully.

[selvajan23]

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 

VBA tags courtesy of www.thecodenet.com

even i tried this

Application.CommandBars("Nokia").Visible = True 

VBA tags courtesy of www.thecodenet.com

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.Its almost 60% finished.

[Jan Karel Pieterse]

Are you sure that commandbar "Nokia" or "Worksheet Nokia" exists?

[selvajan23]

Hey Its not command bar,

I have created a menu bar named "nokia".

i have to hide it for sepearate workbook,
for that i have tried that code which was taken from net,
if my codes are wrong please help me to get it.

[Jan Karel Pieterse]

Could you please attach a screenshot of your "menu bar", so we know what you are talking about?.

[selvajan23]

Please have a look on my nokia menu bar in the attachment,

I have specified that how did i add my menu and also added menu in thaat screenshot.

Now my need is that i need that menu for my single workbook.

if i open any other workbook it shoul not be visible.

Please let me know if you have any other comments.

[Jan Karel Pieterse]

Again. You can't do this with VBA.
Go to Ron de Bruin's website. He explains how to do this stuff here:

http://www.rondebruin.nl/ribbon.htm