Excel settings-unable to run/record macro...help needed

[SG]

Hi Experts,

On opening any excel file, code for Ribbon x comes itself in module which leaves my ecel hanged & also i'm nt able to record or run any macro.
I guess there is some problem due to settings but i'm unable to find it. please help me. PFA sheet for reference.

Thanks

 

[Faseeh]

@SG,

Nothing appears in my VB Window. Do one thing, Go to Addins options, Check the Ribbon X and Click Browse and then delete the add in file. When you will restart, excel will ask to remove the addin as the source file will not be found, so remove it. Hope that works.

 

[SG]

Hi Faseeh,

I have checked but no addin is installed in my excel &
below is the code which is appearing on opening of excel in VBAProject(FUNCRES.xlam) module:-
'Entry point for RibbonX button click
Sub ShowATPDialog(control As IRibbonControl)
Application.Run ("fDialog")
End Sub

'Callback for RibbonX button label
Sub GetATPLabel(control As IRibbonControl, ByRef label)
label = ThisWorkbook.Sheets("RES").Range("A10").Value
End Sub

What i can do now??

 

[Faseeh]

Have you tried unloading FUNCRES.xlam?

 

[Faseeh]

Can you share the workbook, if confidential you can email at faseeh10@hotmail.com

 

[SG]

hey...i got it. I just removed the analysis toolpak & problem is solved.
Sorry for bothering you. Thanks

 

[Faseeh]

Well-done, welcome back any time.