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?
 

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