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
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"klysell" wrote in message ...
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.
--
Kent Lysell
Financial Consultant
Ottawa, Ontario
W: 613.948-9557