urgent help required.

[Smart Akhtar]

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.

 

[Barb Reinhardt]

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

 

[Smart Akhtar]

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

--
HTH,
Barb Reinhardt








- Show quoted text -

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