Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 668
  • Last Modified:

Unprotect Workbook from VBA

Is there a way to unprotect a password protected workbook via vba?
0
fitaliano
Asked:
fitaliano
1 Solution
 
kgerbChief EngineerCommented:
Like this...assuming you know the password.

Sub UnprotectWB()
ActiveWorkbook.Unprotect Password:="123"
End Sub

Open in new window


Kyle
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now