Re: $$Excel-Macros$$ VBA Code for Locking/Unlocking excel sheet using password input form

2009-12-15 Thread Abhishek Jain
Hi Rajender, Well, if we wish to prompt user for a password, the password has to be stored somewhere. I chose a hidden sheet. The sheet Pass is xlveryhidden and can only be accessed via VBA so if we put a password in VBA, it should give some security to it. However, the password may be stored

Re: $$Excel-Macros$$ VBA Code for Locking/Unlocking excel sheet using password input form

2009-12-15 Thread Abhishek Jain
Sure will... Would request to keep group's id in copy of all emails related of the group. Thanks, AJ On Tue, Dec 15, 2009 at 5:12 PM, Rajender Soni soni.rajen...@gmail.comwrote: Hi Thanks for your reply, would request you pls approve my friend request in gmail. Regards Rajender On

Re: $$Excel-Macros$$ VBA Code for Locking/Unlocking excel sheet using password input form

2009-12-15 Thread Abhishek Jain
Well, user can not select the sheet Pass unless he opens the VBA (or creates a macro) which he can't without knowing the VBA password. And ofcourse, as I said earlier, the password stored in that sheet is user's password only, which he ALREADY knows, and can change it anytime. The sheet protect

Re: $$Excel-Macros$$ VBA Code for Locking/Unlocking excel sheet using password input form

2009-12-14 Thread Abhishek Jain
Hi Punnet, I missed an important thing in this file, would sent you corrected file shortly. Regards, AJ On Mon, Dec 14, 2009 at 4:35 PM, Abhishek Jain abhishek@gmail.comwrote: Hi Punit, Please see if attached file helps you. User Password - user User working range - B2:B10 Admin

Re: $$Excel-Macros$$ VBA Code for Locking/Unlocking excel sheet using password input form

2009-12-13 Thread Zilla
You have to be a premium member to dload that file. On Dec 11, 8:42 pm, Nandkumar kakvipure nandkumar.hindust...@gmail.com wrote: Try Dis one http://rapidshare.com/files/106336650/LostPassword.Passware.Kit.Enter... On Fri, Dec 11, 2009 at 8:02 PM, Abhishek Jain abhishek@gmail.comwrote:

Re: $$Excel-Macros$$ VBA Code for Locking/Unlocking excel sheet using password input form

2009-12-13 Thread Abhishek Jain
Hi Nandkumar, Well, I downloaded it (as a free user) - two rar files, extracted them, two more rar files, extracted them too - one exe file, VIRUS ALERT ! (glad to know my antivirus works!), exe gone, I deleted rest of the downloaded package. What is it anyway ? Some kind of lost password

Re: $$Excel-Macros$$ VBA Code for Locking/Unlocking excel sheet using password input form

2009-12-11 Thread Abhishek Jain
Punit, What's the VBA password of your file ? You said you have done something in this file, is it the VBA ? Krgrds, AJ On Thu, Dec 10, 2009 at 12:29 PM, punit poddar p2pod...@gmail.com wrote: Hi The above file will be used by two person - User and the Administrator, administrator can

Re: $$Excel-Macros$$ VBA Code for Locking/Unlocking excel sheet using password input form

2009-12-11 Thread Nandkumar kakvipure
Try Dis one http://rapidshare.com/files/106336650/LostPassword.Passware.Kit.Enterprise.v8.3.0.Retail-ARN.rar On Fri, Dec 11, 2009 at 8:02 PM, Abhishek Jain abhishek@gmail.comwrote: Punit, What's the VBA password of your file ? You said you have done something in this file, is it the VBA

$$Excel-Macros$$ VBA Code for Locking/Unlocking excel sheet using password input form

2009-12-09 Thread punit poddar
Hi The above file will be used by two person - User and the Administrator, administrator can edit anywhere, while the user can edit only in the range specified, based on this I have done something in the file attached but would help you guys to pls help. Please find attached the excel file. 1.