How to add a Custom menu TAB for Seperate work book

[selvamariappan]

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

 

[Domski]

Did you explore all the links in my original post?

Dom

 

[RoryA]

Doubtful - see here.

 

[Domski]

@selvamariappan

Please read this re cross posting: http://www.excelguru.ca/content.php?184

Dom

 

[selvamariappan]

Please help me in code.

I dont know the code.

Please help me

 

[selvamariappan]

hello,

yes i have posted the same problem in that link also for getting quick answer,

this is not a cross posting,

I am in need of urgent answer, so only i posted it ,

Please help me with a code

 

[selvamariappan]

Yes , but i couldnt able to attached the link,

Please help

 

[RoryA]

this is not a cross posting,

yes it is. it is the definition of cross-posting.

 

[selvamariappan]

Yes I agree , Its my mistake , henceforth i wont post the same in two areas.

I have tried the code as below

Private Sub Workbook_Open()
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Nokia"",True)"
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Nokia"",False)"
End Sub

But its the menu is not hiding,

Kindly request you to help to hide the menu.

 

[RoryA]

Your menu is a tab, not a commandbar or toolbar. You need to use the getVisible callback as explained on Ron's site.

 

[selvamariappan]

Thanks for your information.

finally i have created a menu for single workbook,

it contains sub module.earlier i have write my macro code in my excel objects under in a particular sheet.

now when i call that into my module it showing error as

Sub or Function not defined

i have put my function as public in microsoft excel objects in sheet 2,

but i need to call in module which is not able, please help this alone.