Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection property of the VBA project
Hi there Is there a vba code to check the Protection property of the VBA projec in a an Excel File ?. So that a MsgBox tells me that the VBAProject is protecte -- helmekk ----------------------------------------------------------------------- helmekki's Profile: http://www.excelforum.com/member.php...nfo&userid=693 View this thread: http://www.excelforum.com/showthread.php?threadid=39418 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection property of the VBA project
MsgBox Workbooks("Book1.xls").VBProject.Protection = vbext_pp_locked
returns true if the project is locked. -- Jim "helmekki" wrote in message ... | | Hi there | | Is there a vba code to check the Protection property of the VBA project | in a an Excel File ?. | | So that a MsgBox tells me that the VBAProject is protected | | | -- | helmekki | | | ------------------------------------------------------------------------ | helmekki's Profile: http://www.excelforum.com/member.php...fo&userid=6939 | View this thread: http://www.excelforum.com/showthread...hreadid=394181 | |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection property of the VBA project
Use a 1 in place of vbext_pp_locked if you do not have a reference set to VB
extensibility. -- Jim "helmekki" wrote in message ... | | Hi there | | Is there a vba code to check the Protection property of the VBA project | in a an Excel File ?. | | So that a MsgBox tells me that the VBAProject is protected | | | -- | helmekki | | | ------------------------------------------------------------------------ | helmekki's Profile: http://www.excelforum.com/member.php...fo&userid=6939 | View this thread: http://www.excelforum.com/showthread...hreadid=394181 | |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection property of the VBA project
It greatly worked fine Thank u very much indeed -- helmekki ------------------------------------------------------------------------ helmekki's Profile: http://www.excelforum.com/member.php...fo&userid=6939 View this thread: http://www.excelforum.com/showthread...hreadid=394181 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VB Project Protection | Excel Programming | |||
Project Protection | Excel Programming | |||
Project One - Nearly done - Protection issues | Excel Programming | |||
VB project protection | Excel Programming | |||
Worksheet/workbook protection property? | Excel Programming |