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.com>wrote: > Hi > > Thanks for your reply, would request you pls approve my friend request in > gmail. > > Regards > Rajender > > > > On 12/15/09, Abhishek Jain <abhishek....@gmail.com> wrote: >> >> 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 somewhere else >> like in another file or something but I am not aware with that procedure. >> >> By the way the password stored in that sheet is just file open password >> for user. The sheet protect/unprotect password is mentioned in VBA itself. >> >> Kind regards, >> >> Abhishek >> >> >> >> On Tue, Dec 15, 2009 at 4:50 PM, Soni.Rajender >> <soni.rajen...@gmail.com>wrote: >> >>> Hi, >>> The code works absolutely fine, only the drawback is the hiddent sheet >>> "PASS" that can leak the password, is there a way that the sheet >>> "PASS" cannot be accessed, so that user can't view the password >>> >>> Regards >>> Rajender >>> >>> On Dec 15, 2:47 pm, Abhishek Jain <abhishek....@gmail.com> wrote: >>> > Hi Punit, >>> > >>> > Please find attached herewith the corrected file. Have a look on that >>> and >>> > let me know if it is working as per your expectations. >>> > >>> > Regards, >>> > >>> > AJ >>> > >>> >>> > On Tue, Dec 15, 2009 at 10:40 AM, Abhishek Jain < >>> abhishek....@gmail.com>wrote: >>> > >>> > >>> > >>> > > 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.com>wrote: >>> > >>> > >> Hi Punit, >>> > >>> > >> Please see if attached file helps you. >>> > >>> > >> User Password - user >>> > >> User working range - B2:B10 >>> > >> Admin Password - admin >>> > >>> > >> Kind regards, >>> > >>> > >> Abhishek >>> > >>> >>> > >> On Mon, Dec 14, 2009 at 10:42 AM, Abhishek Jain < >>> abhishek....@gmail.com>wrote: >>> > >>> > >>> 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 recovery toolkit ? >>> and if >>> > >>> it is, how's it going to help in this query ? >>> > >>> > >>> Punit - I await your revert. >>> > >>> > >>> Kind regards, >>> > >>> > >>> AJ >>> > >>> >>> > >>> On Sun, Dec 13, 2009 at 10:49 PM, Zilla <zill...@gmail.com> >>> wrote: >>> > >>> > >>>> 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.com>wrote: >>> > >>> > >>>> > > 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 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. Form that will be used to unlock only the current sheet, >>> it will >>> > >>>> be >>> > >>>> > >> better if we give the user option to change the password. >>> > >>>> > >> 2. On closing the file the sheet will automatically gets >>> locked. >>> > >>>> > >> 3. Have give the user the option to edit only a small range >>> of >>> > >>>> cells. >>> > >>> > >>>> > >> Regards >>> > >>>> > >> Punit >>> > >>> > >>>> > >> -- >>> > >>> > >>>> >>> ---------------------------------------------------------------------------------- >>> > >>>> > >> Some important links for excel users: >>> > >>>> > >> 1. Excel and VBA Tutorials(Video and Text), Free add-ins >>> downloads >>> > >>>> at >>> > >>>> > >>http://www.excelitems.com >>> > >>>> > >> 2. Excel tutorials athttp://www.excel-macros.blogspot.com >>> > >>>> > >> 3. Learn VBA Macros athttp://www.vbamacros.blogspot.com >>> > >>>> > >> 4. Excel Tips and Tricks athttp://exceldailytip.blogspot.com >>> > >>> > >>>> > >> To post to this group, send email to >>> excel-macros@googlegroups.com >>> > >>>> > >> If you find any spam message in the group, please send an >>> email to: >>> > >>>> > >> Ayush Jain @ jainayus...@gmail.com or >>> > >>>> > >> Ashish Jain @ 26may.1...@gmail.com >>> > >>>> > >> <><><><><><><><><><><><><><><><><><><><><><> >>> > >>>> > >> HELP US GROW !! >>> > >>> > >>>> > >> We reach over 6,500 subscribers worldwide and receive many >>> nice >>> > >>>> notes >>> > >>>> > >> about the learning and support from the group. Our goal is to >>> have >>> > >>>> 10,000 >>> > >>>> > >> subscribers by the end of 2009. Let friends and co-workers >>> know >>> > >>>> they can >>> > >>>> > >> subscribe to group at >>> > >>>> > >>http://groups.google.com/group/excel-macros/subscribe >>> > >>> > >>>> > > -- >>> > >>> > >>>> >>> ---------------------------------------------------------------------------------- >>> > >>>> > > Some important links for excel users: >>> > >>>> > > 1. Excel and VBA Tutorials(Video and Text), Free add-ins >>> downloads >>> > >>>> at >>> > >>>> > >http://www.excelitems.com >>> > >>>> > > 2. Excel tutorials athttp://www.excel-macros.blogspot.com >>> > >>>> > > 3. Learn VBA Macros athttp://www.vbamacros.blogspot.com >>> > >>>> > > 4. Excel Tips and Tricks athttp://exceldailytip.blogspot.com >>> > >>> > >>>> > > To post to this group, send email to >>> excel-macros@googlegroups.com >>> > >>>> > > If you find any spam message in the group, please send an >>> email to: >>> > >>>> > > Ayush Jain @ jainayus...@gmail.com or >>> > >>>> > > Ashish Jain @ 26may.1...@gmail.com >>> > >>>> > > <><><><><><><><><><><><><><><><><><><><><><> >>> > >>>> > > HELP US GROW !! >>> > >>> > >>>> > > We reach over 6,500 subscribers worldwide and receive many >>> nice >>> > >>>> notes about >>> > >>>> > > the learning and support from the group. Our goal is to have >>> 10,000 >>> > >>>> > > subscribers by the end of 2009. Let friends and co-workers >>> know they >>> > >>>> can >>> > >>>> > > subscribe to group at >>> > >>>> > >http://groups.google.com/group/excel-macros/subscribe >>> > >>> > >>>> -- >>> > >>> > >>>> >>> ---------------------------------------------------------------------------------- >>> > >>>> Some important links for excel users: >>> > >>>> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads >>> at >>> > >>>>http://www.excelitems.com >>> > >>>> 2. Excel tutorials athttp://www.excel-macros.blogspot.com >>> > >>>> 3. Learn VBA Macros athttp://www.vbamacros.blogspot.com >>> > >>>> 4. Excel Tips and Tricks athttp://exceldailytip.blogspot.com >>> > >>> > >>>> To post to this group, send email to >>> excel-macros@googlegroups.com >>> > >>>> If you find any spam message in the group, please send an email >>> to: >>> > >>>> Ayush Jain @ jainayus...@gmail.com or >>> > >>>> Ashish Jain @ 26may.1...@gmail.com >>> > >>>> <><><><><><><><><><><><><><><><><><><><><><> >>> > >>>> HELP US GROW !! >>> > >>> > >>>> We reach over 6,500 subscribers worldwide and receive many nice >>> notes >>> > >>>> about the learning and support from the group. Our goal is to have >>> 10,000 >>> > >>>> subscribers by the end of 2009. Let friends and co-workers know >>> they can >>> > >>>> subscribe to group at >>> > >>>>http://groups.google.com/group/excel-macros/subscribe >>> > >>> > >>> > >>> >>> > Ppod.xls >>> > 109KViewDownload- Hide quoted text - >>> > >>> > - Show quoted text - >> >> >> > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
