View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default urgent help required.

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.