View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Roy Roy is offline
external usenet poster
 
Posts: 53
Default Compile directive for 2000 to ignore 2003 commands

How Can I tell Excel 2000 to ignore VBA command that are not implemented in
2000, but in later version?

"#If VB6 Then" is 'TRUE' for 2000, 2002 and 2003, so I cannot use it. I want
to use the .mask feature on a command button in 2002 and 2003, but I want the
same code to compile under 2000 and ignore the .mask line.

With MenuItem
.Caption = "My Button"
.Mask = frmIcons.Image1.Picture
End With

Also 'Application.Version' doesn't work as a compiler directive.
I need a way for a # compiler command to distinguish between 2000 , 2002 and
Excel 2003.