Running Macro's created in 2003 in 2007

[H&MITGuy]

Hello,

I was recently sent an excel workbook that was created in excel 2003 and has been converted by a user to 2007. However non of the macro's that were created for several button work. As soon as you click on the macro button it throw an error asking to debug the code. Has anyone seen this before or come across a fix other then rebuilding the macro's completely.

If anyone wants to see this awesome macro button please let me know i'll post the code.

thanks in advance.

[DonkeyOte]

Yes please post the offending code.

Does the file utilise a calendar control ?
If you go into the VB Editor in 2007 and go to Tools -> References is anything listed as MISSING ?
(I used CAPS as it will be listed in CAPS on the screen... I'm not shouting ;-)

There's not much in the way of VBA that's not available in 2007 that was available in 2003 ...
the UI is obviously a little different so trying to alter that using old methods is unlikely to work

[H&MITGuy]

Please Login or Register  to view this content.

[DonkeyOte]

Are you able to post the file itself ?

[H&MITGuy]

I am unable to post the file itself. Sorry

[DonkeyOte]

In which case there's not a lot I can do sorry...

I would suggest when the error arises you hit debug and see the code in yellow - this will point you in the direction of the cause...

What I will say is that there appears to be a lot of superfluous code in the routine ... of more interest to you will be the various Offset commands which could easily cause bugs pending the active cell at point of code being executed... for ex. just looking at the first few lines, the below (line 3):

Please Login or Register  to view this content.

Will cause a bug if the active cell is anywhere in the first six rows when the code is invoked given you can not offset by more than 5 rows in an upwards direction (else you're moving off the workheet... ie to row 0 and under which don't exist).