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.
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.
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.
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.
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
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.CommandBars("Worksheet Nokia").Visible = False
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.
Are you sure that commandbar "Nokia" or "Worksheet Nokia" exists?
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.
Could you please attach a screenshot of your "menu bar", so we know what you are talking about?.
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.
Again. You can't do this with VBA.
Go to Ron de Bruin's website. He explains how to do this stuff here: