Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unlock VBA project
I lock my VBA code without using a passward. How do I
unlock it. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unlock VBA project
I can't seem to lock the VBA project without using a
password. I doesn't accept a non-entry. How did you mangage to do this? -----Original Message----- I lock my VBA code without using a passward. How do I unlock it. . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unlock VBA project
I did this more than a year ago so I'm not sure what I did
but I do remember locking the project. Based on what you have said I probably did use a password and I'm pretty certain I know what it is. However, I can't figure out how to unlock it. Your help is greatly appreciated. -----Original Message----- I can't seem to lock the VBA project without using a password. I doesn't accept a non-entry. How did you mangage to do this? -----Original Message----- I lock my VBA code without using a passward. How do I unlock it. . . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unlock VBA project
Hi Gail,
Open the Visual Basic Editor (VBE) by pressing Alt + F11. Then locate your VBA project in the Project Explorer window. This is usually on the left when you open the VBE. Click the plus sign belonging to your project. If the project is locked, you will be prompted for the password. If the Project Explorer is not visible, select it through the View menu item of the VBE Menu Bar. If you cannot remember the password, I'm willing to try to open it for you if you can inspire me with confidence that it's indeed your own code. You'll have to email me the workbook. Note that there is no programmatic way using VBA to unlock a VBA project with the possible exception of using Sendkeys (which I doubt). I'll provide my email address on request. Regards, Greg -----Original Message----- I did this more than a year ago so I'm not sure what I did but I do remember locking the project. Based on what you have said I probably did use a password and I'm pretty certain I know what it is. However, I can't figure out how to unlock it. Your help is greatly appreciated. -----Original Message----- I can't seem to lock the VBA project without using a password. I doesn't accept a non-entry. How did you mangage to do this? -----Original Message----- I lock my VBA code without using a passward. How do I unlock it. . . . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unlock VBA project
Hi Greg,
I have one addin which I created on win2ooo and office 2000. However it does not work properly on off97. I have saved the actual file with a password for the VBA Project but and addin as a different file. now I do not remember the password. I had search all the NG but there is no solution except going for commercial softwares which I am not willing at all. May I expect any help from you in these regard? My mail id is dashashrimaliremove this <<<yahoo.com. Let me assure you that this is created by me and it is my own file. I can write it again but then it will take another 5-6 days to find out the same, research and modify it as per my requirement. Thanks and regards, Malcom. -----Original Message----- Hi Gail, Open the Visual Basic Editor (VBE) by pressing Alt + F11. Then locate your VBA project in the Project Explorer window. This is usually on the left when you open the VBE. Click the plus sign belonging to your project. If the project is locked, you will be prompted for the password. If the Project Explorer is not visible, select it through the View menu item of the VBE Menu Bar. If you cannot remember the password, I'm willing to try to open it for you if you can inspire me with confidence that it's indeed your own code. You'll have to email me the workbook. Note that there is no programmatic way using VBA to unlock a VBA project with the possible exception of using Sendkeys (which I doubt). I'll provide my email address on request. Regards, Greg -----Original Message----- I did this more than a year ago so I'm not sure what I did but I do remember locking the project. Based on what you have said I probably did use a password and I'm pretty certain I know what it is. However, I can't figure out how to unlock it. Your help is greatly appreciated. -----Original Message----- I can't seem to lock the VBA project without using a password. I doesn't accept a non-entry. How did you mangage to do this? -----Original Message----- I lock my VBA code without using a passward. How do I unlock it. . . . . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unlock VBA project
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unlock VBA project
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unlock VBA project
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unlock VBA project | Excel Discussion (Misc queries) | |||
Unlock VBA Project | Excel Discussion (Misc queries) | |||
how do i password protect an .xls file? how do i unlock it for automation. e.g. want to unlock and access a .xls from another .xls macro. | Excel Worksheet Functions | |||
Accesing vba project from wb that has vba project password protected | Excel Programming | |||
unlock project with VBA code | Excel Programming |