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