Can't run macro in Excel 07 after upgrading from 03

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.
timestreamAsked:
Who is Participating?
 
cyberkiwiCommented:
In Excel 2007, macro-enabled workbooks must be saved as .xlsm
Is it still .xls or .xlsx?
0
 
biaogewangCommented:
When you open the Excel 2003 file and save as a 2007 file, save as "Excel Macro-Enabled Workbook (*.xlsm). Otherwise, all macro will be removed in .xlsx format.
0
 
timestreamAuthor Commented:
Saved it as a macro enabled workbook, but the error still came up.
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
cyberkiwiCommented:
Is the Macro actually in "this" workbook?
If you open the xls, then hit Alt-F11 and click on various sheets and the "workbook" node itself, can you see any VBA code?
0
 
luconstaCommented:
How the macro is run - using the workbook name?... if YES then chark your reference to point to the workbook.XLSM.
0
 
Rory ArchibaldCommented:
Move your macro to a normal module rather than a worksheet code module, and you should be fine.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.