Dear everyone I have an Excel file which validates data that a user has
entered, I need to update this but alas after 2 years plus of using this
workbook I have forgotten the password I used to protect the VBA code from
tampering and also the workbook, it appears so much so that even I cannot
update it. Is there a way I can retreive my password, I know exactly what
the syntax is and what the Module name is.

The Module I created is called "Program"
The line of code would be varPassword = "???????????" , I use this syntax
all the time to protect and unprotect during copying and pasting of data and
validation of whats been entered by the user.

Is it possible for me to retieve this line of syntax from within the module
so that I can unprotect the module and update the syntax?

I really do not relishing starting from scratch , I have 16 plus routines of
ruling code to validate the users data within the module.

thanks

Macroman

Go to Google. Type in "Excel, Password". Take your pick...
--
HTH...

Jim Thomlinson


"Macroman" wrote:

Dear everyone I have an Excel file which validates data that a user has
entered, I need to update this but alas after 2 years plus of using this
workbook I have forgotten the password I used to protect the VBA code from
tampering and also the workbook, it appears so much so that even I cannot
update it. Is there a way I can retreive my password, I know exactly what
the syntax is and what the Module name is.

The Module I created is called "Program"
The line of code would be varPassword = "???????????" , I use this syntax
all the time to protect and unprotect during copying and pasting of data and
validation of whats been entered by the user.

Is it possible for me to retieve this line of syntax from within the module
so that I can unprotect the module and update the syntax?

I really do not relishing starting from scratch , I have 16 plus routines of
ruling code to validate the users data within the module.

thanks

Macroman

Jim: are you sure you can find the VBA project pasword??????

"Macroman" wrote:

Dear everyone I have an Excel file which validates data that a user has
entered, I need to update this but alas after 2 years plus of using this
workbook I have forgotten the password I used to protect the VBA code from
tampering and also the workbook, it appears so much so that even I cannot
update it. Is there a way I can retreive my password, I know exactly what
the syntax is and what the Module name is.

The Module I created is called "Program"
The line of code would be varPassword = "???????????" , I use this syntax
all the time to protect and unprotect during copying and pasting of data and
validation of whats been entered by the user.

Is it possible for me to retieve this line of syntax from within the module
so that I can unprotect the module and update the syntax?

I really do not relishing starting from scratch , I have 16 plus routines of
ruling code to validate the users data within the module.

thanks

Macroman

There are a bunch of them in there. To unprotect the code they all charge a
fee that I know of. You probably want to refine the search a bit though.
--
HTH...

Jim Thomlinson


"filo666" wrote:

Jim: are you sure you can find the VBA project pasword??????

"Macroman" wrote:

Dear everyone I have an Excel file which validates data that a user has
entered, I need to update this but alas after 2 years plus of using this
workbook I have forgotten the password I used to protect the VBA code from
tampering and also the workbook, it appears so much so that even I cannot
update it. Is there a way I can retreive my password, I know exactly what
the syntax is and what the Module name is.

The Module I created is called "Program"
The line of code would be varPassword = "???????????" , I use this syntax
all the time to protect and unprotect during copying and pasting of data and
validation of whats been entered by the user.

Is it possible for me to retieve this line of syntax from within the module
so that I can unprotect the module and update the syntax?

I really do not relishing starting from scratch , I have 16 plus routines of
ruling code to validate the users data within the module.

thanks

Macroman

Try a Hex editor. Search for varPassword

"Macroman" wrote in message
...
Dear everyone I have an Excel file which validates data that a user has
entered, I need to update this but alas after 2 years plus of using this
workbook I have forgotten the password I used to protect the VBA code from
tampering and also the workbook, it appears so much so that even I cannot
update it. Is there a way I can retreive my password, I know exactly what
the syntax is and what the Module name is.

The Module I created is called "Program"
The line of code would be varPassword = "???????????" , I use this syntax
all the time to protect and unprotect during copying and pasting of data
and validation of whats been entered by the user.

Is it possible for me to retieve this line of syntax from within the
module so that I can unprotect the module and update the syntax?

I really do not relishing starting from scratch , I have 16 plus routines
of ruling code to validate the users data within the module.

thanks

Macroman