Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to check if the Excel VBE is opened within Excel?
I want to disable the VBE when user opens a secured
workbook. I'v already protected the workbook and worksheets as well as disabled the VBE from the Tool menu when user opens the secured workbook. However, I found that if VBE is opened prior to opening the secured Excel workbook. The user can still look at the supposedly secured codes in the workbook. Can someone please tell me how to check the VBE is already open such. that I can close it as soon as the user opens a secured workbook ? Thanks in advance for your help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to check if the Excel VBE is opened within Excel?
wellie,
The VBA Editor shouldn't be opened unless the user already has it opened from another workbook when they open yours. You could just lock the project with a password and then it wouldn't matter whether the VBA Editor was opened or not. From the VBA Editor..... Tools/VBA Project Properties/Protection Check "Lock Project for Viewing" and enter a passoword. Note: All passwords, Workbook/Worksheet and VBA can be cracked by an experienced user. John wellie wrote: I want to disable the VBE when user opens a secured workbook. I'v already protected the workbook and worksheets as well as disabled the VBE from the Tool menu when user opens the secured workbook. However, I found that if VBE is opened prior to opening the secured Excel workbook. The user can still look at the supposedly secured codes in the workbook. Can someone please tell me how to check the VBE is already open such. that I can close it as soon as the user opens a secured workbook ? Thanks in advance for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check a sheet each time file opened? | Excel Discussion (Misc queries) | |||
use check box created in Excel 2003 opened in Excel 2007 | Excel Worksheet Functions | |||
Excel 2003 when closing Excel after having opened a project locked for viewing.. password prompt??? | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) | |||
Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel |