Since upgrading from excel 03 to 07 I'm now unable to run a macro in a workbook.
I get the error when attempting to run it -
Cannot run the macro "workbookname.xls'!Sheet1.ParseComments'. The macro may not be available in this workbook or all macros may be disabled.
I have macros enabled, and the trust access to VBA project object model enabled. I also have the vba applications installed that come with the office 07 setup.
It was working fine before the upgrade to 07.
Any help would be good, ta.