Compatibility error between Excel 2003 and 2003

[Roy]

I am trying to use the mask button with Excel 2003, but get issues running
under 2000 (I need 2000 to ignore the new commands in later versions)

With MenuItem
.Caption = "My Button"
Sheet1.Shapes(1).Copy
.PasteFace
.Mask = frmIcons.Image1.Picture
End With

The issue is the '.mask' doesn't compile under Excel 2000.

"#If VB6 Then" doesn't help since it's 'TRUE' for 2000 and 2003 as well. Is
there any other compile directive that I can use to distinguish between 2000
, 2002 and 2007 ?

How can I have Excel 2000 ignore this line during compilation?

 

[ShaneDevenshire]

Hi Roy,

Try
IF Application.Version >= 12 then

Else

End IF
--

Cheers,
Shane Devenshire
Microsoft Excel MVP
Join http://setiathome.berkeley.edu/ and download a free screensaver to help
search for life beyond earth.