Prevent to Open file from Excel 2003

[Abhijeet]

Hi

I have Excel 2003 & Excel 2010 install in system and i want to protect to open particular excel file in Excel 2003 means that file do not want to open in 2003 please tell me how to do this

 

[Marc L]

Hi !

I see a way but via VBA (here it's not the appropriate forum) :
at opening (worbook event), just check Excel version
and if it's not the expected, close Excel or workbook …
​

 

[Abhijeet]

Thanks I tried this method and work that

Private Sub Workbook_Open()
If Application.Version = "13.0" Then
        MsgBox "You are using Excel 2010."
        Else
        MsgBox "Please Use Exce2010"
ThisWorkbook.Close
End If
End Sub