ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Unprotect VBA-Code using VBA-Code? (https://www.excelbanter.com/excel-programming/387481-unprotect-vba-code-using-vba-code.html)

Michael Mueller

Unprotect VBA-Code using VBA-Code?
 
Hi.

Here I got one of my older VBA-Projekts, which now causes an error due to
changes of the system it is running on. Normaly it should be solved easily,
but at that time I used a password to protect it's code :-(
I already tried to use my default passwords, but none of them works. It
seems like the only change will be by bruteforce.

Is it therefore possible to unprotect VBA-Code using VBA-Code?

Thanks
Michi



John Bundy

Unprotect VBA-Code using VBA-Code?
 
It depends on whether you are talking about sheet level protection, workbook
protection, or vba protection. The first two are easier and you can google
for code, the third will require 3rd party software as you mentioned.
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"Michael Mueller" wrote:

Hi.

Here I got one of my older VBA-Projekts, which now causes an error due to
changes of the system it is running on. Normaly it should be solved easily,
but at that time I used a password to protect it's code :-(
I already tried to use my default passwords, but none of them works. It
seems like the only change will be by bruteforce.

Is it therefore possible to unprotect VBA-Code using VBA-Code?

Thanks
Michi




Michael Mueller

Unprotect VBA-Code using VBA-Code?
 
Hi.

Is it therefore possible to unprotect VBA-Code using VBA-Code?


Got it solved using SendKeys and lots of time ;-)

Never mind
Michi



Carl Hartness[_2_]

Unprotect VBA-Code using VBA-Code?
 
No. The properties in the object structure having to do with
passwords are read-only. They can only be accessed from the user
interface.

Thinking about it, it is self-defeating to allow code to unprotect
code. That would be a hole that viruses could drive a truck through.

Carl.

On Apr 17, 3:22 am, "Michael Mueller"
wrote:
Hi.

Is it therefore possible to unprotect VBA-Code using VBA-Code?


Got it solved using SendKeys and lots of time ;-)

Never mind
Michi




All times are GMT +1. The time now is 12:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com