Protection property of the VBA project

[helmekki]

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

[Jim Rech]

MsgBox Workbooks("Book1.xls").VBProject.Protection = vbext_pp_locked

returns true if the project is locked.

--
Jim
"helmekki" <[email protected]> wrote in
message news:[email protected]...
|
| 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
|

[Jim Rech]

Use a 1 in place of vbext_pp_locked if you do not have a reference set to VB
extensibility.

--
Jim
"helmekki" <[email protected]> wrote in
message news:[email protected]...
|
| 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
|

[helmekki]

It greatly worked fine

Thank u very much indeed