Excel 2007 : xl2002 macros halting on xl2007

[Gabor]

Hi Folks,

I am about to switch over to 2007 at my Company and I was provided a test PC to try my stuff out with the comment some of the functionalities will not be available with 2007.
And that is very much the case...

1st of all what is the best place to seek for help on those issues?

2nd: I have the following not working on a worksheet module just as an example:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Me.Range("MyNamedRange")) Is Nothing Then
       With Target
       MyCode
       End With
    End If
End Sub

Any substitute for this?

Thanks

Gábor

[royUK]

Hi Folks,

I am about to switch over to 2007 at my Company and I was provided a test PC to try my stuff out with the comment some of the functionalities will not be available with 2007.
And that is very much the case...

What's not functional, 2007 has more features than 2003 - enhanced colours, enhanced Conditional Formatting etc.

1st of all what is the best place to seek for help on those issues?

This Forum?

2nd: I have the following not working on a worksheet module just as an example:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Me.Range("MyNamedRange")) Is Nothing Then
       With Target
       MyCode
       End With
    End If
End Sub

Any substitute for this?

Thanks

Gábor

There's no reason why that code should not work in 2007, have you changed the workbook to a 2007 *.xlsm format or used the compatbility pack- see http://www.excel-it.com/Excel%202007...lity_pack.htm?

[Simon Lloyd]

Remeber that a saved workbook in xl2007 now has to be specifically saved to work with macros!, it's not that functionality is unavailable its just in a different place, the ribbon doesnt seem to have the same logic of placing as previous menu's it will take a little while to work around plus you can customise it to look as you want!

[Gabor]

I just opened some of my files and the macros I have written during the last 4 years with blood sweat and tears just do not work on xl2007.
Why no continuity?
Why no backwards-compatibility?
What sort of marketing policy is this?
Why would I go and save all my files with another extention? Waste.
These guys are just causing me heeps of non-value-added, tonns of waste and frustration.
I guess I quit pc, go to the attic, look for my abacus.

[Gabor]

Roy,
The compatibility pack is for xl2003 and it is to enable it to open and edit xl2007 files. So it is of no help to me.
Enhanced colours and conditional formatting don't mean a bit when main functionalities are not operational anymore.

Simon,
Under functionality I mean functionalities in VBA, like the one I posted with the Target thing. Some hidden function buttons on the ribbon I can find, no probs with that.

In the example I posted the macro should run if the worksheet has been changed and a cell has been changed within a particular named range. It runs aok in 2002 and it doesn't in 2007.

What is the solution for this task in 2007 ?