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

 

[selvamariappan]

Hello,

Thanks for your support, I have created a menu in my single workbook with your link.

But my problem is not solved, i have three sheets in my workbook, i have written my macro in sheet2 page.
my macro function is

Public function sample()
msgbox " test"
End function

I need to call this sample() function in my newly created module.

I have tried the code as

Sub Macro1(control As IRibbonControl)
Call Application.WorksheetFunction.sample
End Sub

But i am getting error as : Run time error : '438'
Object doesn't support this property or method

Please help me , how to call my sheet function in my module.

Thanks in advance.

This is will end my all problem.

 

[RoryA]

sample is not a member of worksheetfunction - it's a function you created, so it's just:

Call sample

 

[selvamariappan]

Thanks for your kind reply,

If i use just call , it showing error as

"Compile error:
Sub or Function not defined"

Please what is error in my code.

 

[RoryA]

Sorry - I missed that you had put in a worksheet module for some reason. You need:

Call sheet2.sample

 

[selvamariappan]

Oh thats great and good , its working fine,

sorry,sorry one more prob/doubt

It's calling my function sample, but i have called another function within that sample function , but it show error as
"Compile error:Variable not defined"

My code in sheet 2 is

Public function sample()
dim OuterloopRow as Integer
OuterloopRow=2

Sheet2.calcul row1:=OuterloopRow
End function

Public function calcul (ByVal row1 As Integer)
msgbox "test"
End function

Please assist.

 

[RoryA]

that code works fine for me.

 

[selvamariappan]

Thanks a lot for your all support till this time,

Its my mistake and i have tried to use a variable from one function to another function , finally I have declared it as global variable and works fine what i expected.

Every thing work for me.

"Expert makes perfect"

"Thanks a lot for your great support towards the end, especially with lot of patience."

Regards,
Selva.C

 

[RoryA]

Glad to help.

 

[selvamariappan]

Hello,

Sorry for disturbing,

Onemore problem,I have created a single menu and with an option and i am using excel 2010.Its working what i expected in excel 2010,.

Note : when i open that file in 2010 , it will ask for Protected view : need to edit click here like that.

But when i tried to open it through 2007 in other system, i am not getting that menu in my tab list.

Please help me,

 

[RoryA]

how did you add the menu? did you use a customui14 part?