Thread: Check VBAproject is protected or not
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Check VBAproject is protected or not
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
Reply With QuoteReply With Quote