I create shared workbooks for my coworkers all the time. For some reason, they keep crashing giving error messages about some unreadable content and named ranges (when there are no named ranges). The only common thing that I can find is this Ribbon X code
that is created in every workbook I create.
Is this necessary? Can I delete it? What is it for? Could it be the cause?
'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