Excel Hints

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.

    Regards,
    Selva.C

  2. #2

  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.
    Regards,

    Jan Karel Pieterse
    Excel MVP
    JKP Application Development Services
    www.topexcelclass.com

  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.
    Regards,

    Jan Karel Pieterse
    Excel MVP
    JKP Application Development Services
    www.topexcelclass.com

  7. #7

    Post

    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
    [/VBA]
    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?
    Regards,

    Jan Karel Pieterse
    Excel MVP
    JKP Application Development Services
    www.topexcelclass.com

  9. #9

    Post

    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?.
    Regards,

    Jan Karel Pieterse
    Excel MVP
    JKP Application Development Services
    www.topexcelclass.com

  11. #11

    Post

    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
      To view attachments your post count must be 0 or greater. Your post count is 0 momentarily.

  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:

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

    Jan Karel Pieterse
    Excel MVP
    JKP Application Development Services
    www.topexcelclass.com

Posting Permissions

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