Need to preventt xlsm file from being converted to xls

[frank_m]

I need users that attempt to open my 2007 .xlsm workbook in 2003 to get a msgbox and have it close before the 2007-to-2003-converter-utility has a chance to run.

And if possible it would be great if I could have the before save event in 2007 prevent conversion that way as well.

Thanks

[mancubus]

my thread was about "only open the file in excel 2003".

below is what "pascal" provided.

[vba]

Private Sub Workbook_Open()
If Not Application.Version <> "11.0" Then
MsgBox "Please only open this file in Excel 2003"
ThisWorkbook.Close
End If
End Sub

[/vba]

so perhaps...(goes to ThisWorkbook)
not tested. try with a backup pls.

[vba]

Private Sub Workbook_Open()
If Application.Version <> "12.0" Then
MsgBox "Please only open this file in Excel 2007"
ThisWorkbook.Close
End If
End Sub

[/vba]

[mancubus]

i must add....

you have to force users enable macros, (if don't know how, check:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=379 )

and password protect your vba project.