disabled items Excel --> Help --> about

[christhedonstar]

Hi,

Sometimes an addin e.g. mscorlib gets disabled when excel crashes. I need to programmatically reenable it. Anyone know how to do this?

Cheers,

Chris

 

[CautionMP]

christhedonstar,
I've never done this but I was reading about it earlier this week. I think this will get you moving down the right path.

Application.COMAddIns("[i]Addin Description[/i]").Connect = True

Hope this helps,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)