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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.