Results 1 to 12 of 12

Thread: How to add a Custom menu TAB for Seperate work book

  1. #1

    Post How to add a Custom menu TAB for Seperate work book

    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.


  2. #2

    Jan Karel Pieterse
    Excel MVP

  3. #3
    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.

  4. #4
    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.

    Jan Karel Pieterse
    Excel MVP

  5. #5
    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.

  6. #6
    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.

    Jan Karel Pieterse
    Excel MVP

  7. #7


    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

    [VBA]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
    [VBA]Application.CommandBars("Nokia").Visible = True[/VBA]

    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.

  8. #8
    Are you sure that commandbar "Nokia" or "Worksheet Nokia" exists?

    Jan Karel Pieterse
    Excel MVP

  9. #9


    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.

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

    Jan Karel Pieterse
    Excel MVP

  11. #11


    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.
    Attached Images Attached Images

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

    Jan Karel Pieterse
    Excel MVP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts