Prevent opening solution on other (older) versions (Excel 2000) et

[Guest]

Hi,

I have an Excel Solution that I am nearing completion. I've recently noticed
that if I open my workbook using Excel 2000, my protection is rendered
useless. I'm using a protection that is activated upon opening up the
workbook. It appears that Excel 2000 is not engaging this protection code for
the workbook and thus the user is ablet to delete worksheets, etc.

How do I prevent a user from opening up my solution using any version below
Excel 2003?

Any suggestions would be immensely helpful!

TIA,
Kent.

 

[Ron de Bruin]

Hi klysell

You can test the Application.Version in the workbook open event and close the file if it is not correct

If Val(Application.Version) < 11 Then
MsgBox "You must run Office 2003 or higher, you can't use this Add-in.", _
vbOKOnly, "My Add-in Name"
ThisWorkbook.Close False
Exit Sub
End If

 

[Guest]

Thanks Ron!