Forgotten Password
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 |
Forgotten Password
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 |
Forgotten Password
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 |
Forgotten Password
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 |
Forgotten Password
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 |
All times are GMT +1. The time now is 09:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com