Compatibility error between Excel 2003 and 2003


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

Advertisements

S

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top