why am i seeing this each time i open a new Excel Workbook

[James__S]

Each time i open a new excel 2010 Workbook i see this in the Developer Tab -

A module - RibbonX_Code

'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

How do i get rid of this please?

I do not know how it got in there....

 

[RoryA]

There is no need to actually delete them. You can, as Jan Karel already stated, just uncheck them in the Addins dialog box, so they don't load when Excel starts.

 

[robertking]

Agreed - except in my case (and I do admit I didn't actually state this in my post) they didn't appear in the Addins dialog box! No-one could work out why they were not there, but they most definitely were not! In fact no addin of any sort were listed. General consensus was some sort of corruption had occurred, no idea when or who or how though. Therefore the delete does the job.

 

[RoryA]

That sounds like perhaps your options had been changed to open all files in that folder at startup. I'd suggest that fixing that was a better option than deleting the add-ins themselves.

 

[jkpieterse]

There is no need to delete them, unchecking them in the add-ins list suffices.

 

[robertking]

There is no need to delete them, unchecking them in the add-ins list suffices.

Need to delete them when (as I said above) they do not appear in the add-ins list. That window is completely empty of entries. All entries. Therefore delete. I actually posted my comments to help people, but ever since all I've got back are comments along the line of "you're wrong" Don't know why I bothered.

 

[jkpieterse]

That sounds like a problem in your Excel options. Perhaps the reistry entry for Excel options needs to be rebuilt

You can do that by closing all Excel instances and then deleting this key: HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options
Excel rebuilds the key with the default settings as you restart Excel.

***WARNING BACKUP THE KEY BEFORE DELETING. DO NOT MESS WITH THE REGISTRY UNLESS YOU KNO WHAT YOU'RE DOING***