#26 Compare_ClickHandler macro cannot run

[Anonymous]

Spreadsheet_Compare v1.20 was working fine with my Excel 2007 a couple weeks back. It started to show me that the macro cannot be run although the lowest security level has been set. Trying to upgrade to a newer version, it shows automation error instead.

[SteveT]

Apparently it may be caused by a recent Microsoft security patch. Try the
steps here:

http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2012 /08/15/quot-unspecified-automation-error-quot-after-applying-ms12-060.aspx

[Anonymous]

Any suggestions on how to fix the issue above, since the blog is no longer active

[SteveT]

Did you try the patch indicated?

[SteveT]

Here is the link:

http://blogs.technet.com/b/wordonenotesupport/archive/2012/08/16/quot-unspecified-automation-error-quot-after-applying-ms12-060.aspx