Solved

Unprotect Workbook from VBA

Posted on 2011-09-30
1
593 Views
Last Modified: 2012-05-12
Is there a way to unprotect a password protected workbook via vba?
0
Comment
Question by:fitaliano
1 Comment
 
LVL 12

Accepted Solution

by:
kgerb earned 500 total points
ID: 36893389
Like this...assuming you know the password.

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

Open in new window


Kyle
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
excel formatting with conditional formatting 2 43
vba for Saving access tables to excel with password 4 27
VBA modules import 4 57
copy same as above data 18 40
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question