Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check VBAproject is protected or not
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check VBAproject is protected or not
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 = VBAProject("Project Name").Protected If Answer is yes, the project is protected. Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=505910 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check VBAproject is protected or not
Thank u very much -- helmekki ------------------------------------------------------------------------ helmekki's Profile: http://www.excelforum.com/member.php...fo&userid=6939 View this thread: http://www.excelforum.com/showthread...hreadid=505910 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Check if Worksheet TAB is protected or Not | Excel Discussion (Misc queries) | |||
Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
password protected a check box | Excel Worksheet Functions | |||
check if protected | Excel Programming | |||
Check if activesheet is protected | Excel Programming |