Check VBAproject is protected or not

[helmekki]

Hi there

Is there a vba code to check if the VBAproject is protected or not , and if not some action will be done ?

[Leith Ross]

Hello Hesham,

If you have another Workbook open along with your project then the answer is yes. You must add a reference to the VBA Extensibility Library for this code to work.

Answer = VBProject("Project Name").Protected

If Answer is yes, the project is protected.

Sincerely,
Leith Ross

[Dave Peterson]

something like:

If ActiveWorkbook.VBProject.Protection Then
MsgBox "Protected project" & vbLf & "Cannot complete"
Exit Sub
End If



helmekki wrote:
>
> Hi there
>
> Is there a vba code to check if the VBAproject is protected or not ,
> and if not some action will be done ?
>
> --
> helmekki
>
> ------------------------------------------------------------------------
> helmekki's Profile: http://www.excelforum.com/member.php...fo&userid=6939
> View this thread: http://www.excelforum.com/showthread...hreadid=505910

--

Dave Peterson

[helmekki]

Thank u very much