something like this:


Sub ProtectSht(sht)
sht.Protect Password:=pwd, DrawingObjects:=True, contents:=True
Scenarios:=True
End Sub


Sub UnprotectSht(sht)
sht.Unprotect Password:=pwd
End Sub


Manges

--
mangesh_yada
-----------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047
View this thread: http://www.excelforum.com/showthread.php?threadid=37385

Thank u 4 your reply

i ment is there a vba code to remove protection from the protected vb
project ?

sometimes vba projects are protected, so i am lookinf for a code t
remove protection from the protected vba project ........

the code to remove protection might be placed in a workbook and be use
to remove protection from a protected vba project that exists in
different workbook

--
helmekk

-----------------------------------------------------------------------
helmekki's Profile: http://www.excelforum.com/member.php...nfo&userid=693
View this thread: http://www.excelforum.com/showthread.php?threadid=37385