Can I unprotect any sheet through vba if it is protected with
password.

Please help with code , I need some urgent help on this..

Pleae help me with vba code . sample , I doe's not want any xl addins
file.

Thanks in advance.

ActiveSheet.Protect Password:="myPassword", DrawingObjects:=True,
Contents:=True, Scenarios:=True 'Default settings for protection
ActiveSheet.Unprotect Password:="myPassword"

--
HTH,
Barb Reinhardt



"Smart Akhtar" wrote:

Can I unprotect any sheet through vba if it is protected with
password.

Please help with code , I need some urgent help on this..

Pleae help me with vba code . sample , I doe's not want any xl addins
file.

Thanks in advance.

On Apr 19, 3:40*am, Barb Reinhardt
wrote:
* * ActiveSheet.Protect Password:="myPassword", DrawingObjects:=True,
Contents:=True, Scenarios:=True 'Default settings for protection
* * ActiveSheet.Unprotect Password:="myPassword"

--
HTH,
Barb Reinhardt



"Smart Akhtar" wrote:
Can I unprotect any sheet through vba if it is protected with
password.

Please help with code , I need some urgent help on this..

Pleae help me with vba code . sample , I doe's not want any xl addins
file.

Thanks in advance.- Hide quoted text -

- Show quoted text -

if I forgot the password. then how I can unprotect the sheet ?