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?

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.

"Roy" wrote:

> 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?
>