2003 / 2007 Compatibility Display Picture on Cell Value

[kingpin1984]

Hi There,

I have written some code in vba which works brilliantly on my excel version however, when excel is opened in 2003 the picture functionality no longer works.

What I want is for the pictures to be displayed depending on the cell value. Is there something I need to do to enable this to work in excel 2003 as well as 2007?

Private Sub Worksheet_Change(ByVal Target As Range)</SPAN>
 
ActiveSheet.Shapes("I1").Visible = False</SPAN>
ActiveSheet.Shapes("IR1").Visible = False</SPAN>
ActiveSheet.Shapes("F1").Visible = False</SPAN>
ActiveSheet.Shapes("E1").Visible = False</SPAN>
ActiveSheet.Shapes("W1").Visible = False</SPAN>
ActiveSheet.Shapes("S1").Visible = False</SPAN>
 
If Range("N4") = "England" Then ActiveSheet.Shapes("E1").Visible = True</SPAN>
If Range("N4") = "France" Then ActiveSheet.Shapes("F1").Visible = True</SPAN>
If Range("N4") = "Ireland" Then ActiveSheet.Shapes("IR1").Visible = True</SPAN>
If Range("N4") = "Wales" Then ActiveSheet.Shapes("W1").Visible = True</SPAN>
If Range("N4") = "Italy" Then ActiveSheet.Shapes("I1").Visible = True</SPAN>
If Range("N4") = "Scotland" Then ActiveSheet.Shapes("S1").Visible = True</SPAN>
 
End Sub</SPAN>

Thanks for reading!

 

[Andrew Poulsom]

In what way doesn't your code work in Excel 2003? Are macros enabled?

 

[kingpin1984]

In what way doesn't your code work in Excel 2003? Are macros enabled?

Yeah macros are enabled and everything but when the cell value changes I don't get my picture.

 

[Andrew Poulsom]

Are you sure that the event is firing? Put a MsgBox in there to check.

 

[kingpin1984]

Are you sure that the event is firing? Put a MsgBox in there to check.

Yes it is working fine but then again I am currently working with a newer version of excel. If it helps, when I save the document I get this message from the compatability check:

"This object will no longer be editable. Location: Myworksheet, Shapes"

Thanks for your help!

 

[Andrew Poulsom]

What sort of objects are they that aren't backwardly compatible?

 

[kingpin1984]

What sort of objects are they that aren't backwardly compatible?

They are a clipart image (when using 2007, not sure if theyre in 2003) that have been recoloured only.

 

[Andrew Poulsom]

Maybe it's the recolouring that isn't compatible.