Compatibility error between Excel 2003 and 2003

  • Thread starter Thread starter Roy
  • Start date Start date
R

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