PDA

View Full Version : Need to preventt xlsm file from being converted to xls



frank_m
02-16-2011, 07:36 PM
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
02-17-2011, 01:41 AM
my thread was about "only open the file in excel 2003".

below is what "pascal" provided.



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


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



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

mancubus
02-17-2011, 02:20 AM
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.