Unprotect Modules

[Todd]

In VB I am opening an Excel file and am trying to run a
macro that resides in it. The only problem is the module
is protected. What is the syntax to unprotect a module.

 

[jaf]

Hi Todd,
There is none.
There is a rumor some have suceeded with a brute force sendkeys routine.
I've never seen any code examples.

Protection on a module won't prevent code from being run.

--
John
johnf 202 at hotmail dot com


| In VB I am opening an Excel file and am trying to run a
| macro that resides in it. The only problem is the module
| is protected. What is the syntax to unprotect a module.

 

[Mike Walker]

Hi Todd,

You can unprotect the module in the VBA Editor window under Tools Properties
and clear the password down if you know it, if you don't know the password
you will need a password recovery application there are a few on the market,

Rgds

Mike Walker
(Reply via NG)

 

[timatey]

Hi, if you don't know password
recommend you to use Password recovery for VBA modules (macros) in
Word and Excel documents http://lastbit.com/vba
Best regards, Tim