| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent opening solution on other (older) versions (Excel 2000) et
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Prevent opening solution on other (older) versions (Excel 2000) et
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Prevent opening solution on other (older) versions (Excel 2000
Thanks Ron!
-- Kent Lysell Financial Consultant Ottawa, Ontario W: 613.948-9557 "Ron de Bruin" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Older Versions of Excel | Excel Discussion (Misc queries) | |||
| Older versions of Excel | Excel Discussion (Misc queries) | |||
| Opening .xlsm workbooks in older versions of excel | Excel Discussion (Misc queries) | |||
| Office 07 opening older versions in compatibility mode-min/maximiz | Excel Discussion (Misc queries) | |||
| Prevent recalculation when opening earlier versions | Excel Programming | |||
Linear Mode
