Macros not working after upgrade to v2010

[Boomn4x4]

***** EDIT *****
Never mind... I'm an idiot

The problem was I deleted a column from the worksheet the same time the upgrade happened and I never changed the test column to reflect the now missing column... column 9 is now column 7

Please disrgard.

**********************Original post is below**************************




I have some VBA that simply move a row to the last row of another worksheet.... worked fine.

Recently, my company upgraded (without telling any one or allowing any one to test anything out) to version 2010. Now, none of my maros work. If I click on the View Macros, nothing is listed there. If I right click on the sheet tab and select "View Code".... the VBA is all still there.... but dosen't execute.

Here is the code of one of my macros

Please Login or Register  to view this content.

I have gone into File -> Options -> Trust Center -> Trust Center Settings-> Marco Settings and set "Enable all macros" as well as checking "Trust access to the VBA project object model".... with no luck.

Any help would be appreciated.

[Boomn4x4]

I have also now Saved As and Macro-Enabled Worksheet.... Still no luck.

[MarvinP]

Hi Boomn4x4,

First -
To see why the code isn't triggering, set a breakpoint and step through your code. If there is an error created you will see it jump at that line down to your ErrHnd:

I believe 2010 is backward compatible with all (most?) 2003 macros. There are huge differences on how the file is saved and a complete redo of come components (like charting) between 2003 and 2007.

Second -
I'd remark out the Application.EnableEvents = False and see if that was hurting something.

Third -
Using one above, the event may not even be getting triggered. You will know by setting a breakpoint in the code if the event is triggered.

hope one of the above finds the problem.

[MarvinP]

Ah Ha,

Stepping through the code would not have caused an error, it would have simply not met the If conditon and jumped the code.

Answer one would have worked.

[royUK]

Is this solved? What does your edit to the first post mean?