Dear Dilip, I can't see the codes. How shal I get codes. Please help me......I am not comfortable with VBA.
And what is the password. Thanks in advance Kalyan On Thu, Sep 9, 2010 at 12:01 AM, Dilip Pandey <dilipan...@gmail.com> wrote: > Hi kalyan, > > This is not possible without vba as u r asking for a sheet to be > available on password, else u can simply go ahead n use protect sheet > option available under Tools menu. > > Best Regards, > DILIPandey > > On 9/8/10, Kal xcel <kalx...@gmail.com> wrote: > > Hi Dilip, > > > > Thanks a lot for your help, but I am not comfortable with VBA. > > > > is it possible without macro. > > > > Thanks > > > > Kalyan > > > > > > > > On Tue, Sep 7, 2010 at 8:15 PM, Dilip Pandey <dilipan...@gmail.com> > wrote: > > > >> Hi Vamsi, > >> > >> Password is there in the cell B1 of RSM sheet, which is there for the > >> owner/admin of the workbook. > >> > >> If you are learning this stuff, then pw is of no use to you rather you > >> should try creating this type of workbook on your own. :) > >> > >> Please feel free to get back in case any help is required. > >> > >> Best Regards, > >> DILIPandey > >> > >> On 9/7/10, Vamsi Tatipamula <vamsi.tatipam...@infotech-enterprises.com> > >> wrote: > >> > Thanks dilip for your explanation. > >> > Can you share the password for that excel to open RSM sheet. > >> > > >> > > >> > Regards, > >> > vamsi > >> > > >> > -----Original Message----- > >> > From: Dilip Pandey [mailto:dilipan...@gmail.com] > >> > Sent: Tuesday, September 07, 2010 3:14 PM > >> > To: Vamsi Tatipamula > >> > Cc: excel-macros@googlegroups.com > >> > Subject: Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet > >> > > >> > Hi Vamsi, > >> > > >> > Thanks for your continuous interest. > >> > The VBA macro is working fine in my system and the code which you have > >> > mentioned is just for testing purpose and is not getting used > >> > anywhere. > >> > The code which is actually hiding the rsm sheet while opening is :- > >> > > >> > Private Sub Workbook_Open() > >> > Sheets("RSM").Visible = xlSheetVeryHidden > >> > Sheets("Sheet1").Select > >> > End Sub > >> > > >> > Best Regards, > >> > DILIPandey > >> > > >> > > >> > On 9/7/10, Vamsi Tatipamula < > vamsi.tatipam...@infotech-enterprises.com> > >> > wrote: > >> >> Hi, > >> >> > >> >> Its very interesting... > >> >> > >> >> But if I saved the worksheet after unhiding the sheet, later if I > >> reopened > >> >> the spreadsheet, sheet ASM must be hidden automatically right. But > it > >> is > >> >> not happening.. > >> >> > >> >> > >> >> And what is the use of this code.. > >> >> > >> >> Sub openn() > >> >> Sheets("ASM").Visible = xlSheetVeryHidden > >> >> 'Sheets("ASM").Visible = True > >> >> End Sub > >> >> > >> >> > >> >> Regards, > >> >> Vamsi > >> >> > >> >> -----Original Message----- > >> >> From: Dilip Pandey [mailto:dilipan...@gmail.com] > >> >> Sent: Tuesday, September 07, 2010 10:45 AM > >> >> To: Vamsi Tatipamula > >> >> Cc: excel-macros@googlegroups.com > >> >> Subject: Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet > >> >> > >> >> Hi, > >> >> > >> >> This code is hiding the ASM sheet, which is then can not be un-hide > by > >> >> a user by menu commands unless the user goes for VBA option. This is > >> >> why code syntax says veryhidden. :) > >> >> > >> >> Best Regards, > >> >> DILHPandey > >> >> > >> >> On 9/7/10, Vamsi Tatipamula < > vamsi.tatipam...@infotech-enterprises.com> > >> >> wrote: > >> >>> Dear Dilip, > >> >>> > >> >>> That explains a lot. > >> >>> > >> >>> I didn't understood the below code > >> >>> > >> >>> 'Sheets("ASM").Visible = xlSheetVeryHidden > >> >>> > >> >>> Can u explain this. > >> >>> > >> >>> > >> >>> Regards, > >> >>> Vamsi > >> >>> > >> >>> -----Original Message----- > >> >>> From: Dilip Pandey [mailto:dilipan...@gmail.com] > >> >>> Sent: Monday, September 06, 2010 10:11 PM > >> >>> To: Vamsi Tatipamula > >> >>> Cc: excel-macros@googlegroups.com; kalx...@gmail.com > >> >>> Subject: Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide > Sheet > >> >>> > >> >>> Hi Vamsi, > >> >>> > >> >>> Sure.. below is explanation:- > >> >>> > >> >>> Requirements were to unprotect and unhide a worksheet only if a user > >> >>> enters correct password to do the same. > >> >>> > >> >>> What I have done I have instructed Excel to hide that side while > >> >>> opening (Worksheet Open Event) and given a button for a user to > click > >> >>> if he/she wants that hidden sheet to unhide. See protection or > >> >>> unprotection of a sheet does'nt matter if you are not seeing that > and > >> >>> this is what I have done here. If the user is able to unhide the > >> >>> sheet then only he / she can edit the same. So if the user click on > >> >>> the button, it will ask for a password which is there in the cell B1 > >> >>> of the hidden sheet, (which the admin can control / edit), and if > the > >> >>> password matches the hidden worksheet opens up. > >> >>> > >> >>> Press Alt + F11 to see the codes. > >> >>> > >> >>> Get back in case of any queries. :) > >> >>> > >> >>> Best Regards, > >> >>> DILIPandey > >> >>> > >> >>> > >> >>> > >> >>> On 9/6/10, Vamsi Tatipamula < > vamsi.tatipam...@infotech-enterprises.com > >> > > >> >>> wrote: > >> >>>> Dear Dilip, > >> >>>> > >> >>>> May I know how did you done this.. > >> >>>> > >> >>>> Regards, > >> >>>> vamsi > >> >>>> > >> >>>> -----Original Message----- > >> >>>> From: excel-macros@googlegroups.com > >> >>>> [mailto:excel-mac...@googlegroups.com] > >> >>>> On Behalf Of Dilip Pandey > >> >>>> Sent: Monday, September 06, 2010 5:22 PM > >> >>>> To: Kal xcel; excel-macros@googlegroups.com > >> >>>> Subject: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet > >> >>>> > >> >>>> Dear Kalyan, > >> >>>> > >> >>>> Attached spreadsheet has been solved as per your requirement(s). > >> >>>> > >> >>>> Note:- Going forward please mark the group as well while marking > the > >> >>>> query > >> >>>> email to me. By doing this you can get instant response in case I > am > >> not > >> >>>> available. :) Thanks. > >> >>>> > >> >>>> Best Regards, > >> >>>> DILIPandey > >> >>>> > >> >>>> On 9/6/10, Kal xcel <kalx...@gmail.com> wrote: > >> >>>>> Dear Dilip, > >> >>>>> > >> >>>>> I need a help...........How to protect & hide(Both together) a > >> >>>>> sheet? > >> >>>>> > >> >>>>> In attached file I need to "RSM" sheet will be password protected > & > >> >>>>> hide, if anybody wants to unhide the sheet it will ask password, > >> after > >> >>>>> giving password it will open. > >> >>>>> > >> >>>>> Is it possible? > >> >>>>> > >> >>>>> Thanks in advance > >> >>>>> > >> >>>>> Kalyan > >> >>>>> > >> >>>> > >> >>>> > >> >>>> -- > >> >>>> Thanks & Regards, > >> >>>> > >> >>>> DILIP KUMAR PANDEY > >> >>>> MBA-HR,B.Com(Hons),BCA > >> >>>> Mobile: +91 9810929744 > >> >>>> dilipan...@gmail.com > >> >>>> dilipan...@yahoo.com > >> >>>> New Delhi - 62, India > >> >>>> > >> >>>> -- > >> >>>> > >> > ---------------------------------------------------------------------------------- > >> >>>> Some important links for excel users: > >> >>>> 1. Follow us on TWITTER for tips tricks and links : > >> >>>> http://twitter.com/exceldailytip 2. Join our LinkedIN group @ > >> >>>> http://www.linkedin.com/groups?gid=1871310 > >> >>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com > >> >>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel > Tips > >> >>>> and > >> >>>> Tricks at http://exceldailytip.blogspot.com > >> >>>> > >> >>>> To post to this group, send email to excel-macros@googlegroups.com > >> >>>> > >> >>>> <><><><><><><><><><><><><><><><><><><><><><> > >> >>>> HELP US GROW !! > >> >>>> > >> >>>> We reach over 7000 subscribers worldwide and receive many nice > notes > >> >>>> about > >> >>>> the learning and support from the group.Let friends and co-workers > >> know > >> >>>> they > >> >>>> can subscribe to group at > >> >>>> http://groups.google.com/group/excel-macros/subscribe > >> >>>> > >> >>>> DISCLAIMER: > >> >>>> > >> >>>> This email may contain confidential information and is intended > only > >> for > >> >>>> the > >> >>>> use of the specific individual(s) to which it is addressed. If you > >> >>>> are > >> >>>> not > >> >>>> the intended recipient of this email, you are hereby notified that > >> >>>> any > >> >>>> unauthorized use, dissemination or copying of this email or the > >> >>>> information > >> >>>> contained in it or attached to it is strictly prohibited. If you > >> >>>> received > >> >>>> this message in error, please immediately notify the sender at > >> Infotech > >> >>>> or > >> >>>> mail.ad...@infotech-enterprises.com and delete the original > message. > >> >>>> > >> >>> > >> >>> > >> >>> -- > >> >>> Thanks & Regards, > >> >>> > >> >>> DILIP KUMAR PANDEY > >> >>> MBA-HR,B.Com(Hons),BCA > >> >>> Mobile: +91 9810929744 > >> >>> dilipan...@gmail.com > >> >>> dilipan...@yahoo.com > >> >>> New Delhi - 62, India > >> >>> > >> >>> > >> >> > >> >> -- > >> >> Sent from my mobile device > >> >> > >> >> Thanks & Regards, > >> >> > >> >> DILIP KUMAR PANDEY > >> >> MBA-HR,B.Com(Hons),BCA > >> >> Mobile: +91 9810929744 > >> >> dilipan...@gmail.com > >> >> dilipan...@yahoo.com > >> >> New Delhi - 62, India > >> >> > >> >> > >> > > >> > > >> > -- > >> > Thanks & Regards, > >> > > >> > DILIP KUMAR PANDEY > >> > MBA-HR,B.Com(Hons),BCA > >> > Mobile: +91 9810929744 > >> > dilipan...@gmail.com > >> > dilipan...@yahoo.com > >> > New Delhi - 62, India > >> > > >> > >> -- > >> Sent from my mobile device > >> > >> Thanks & Regards, > >> > >> DILIP KUMAR PANDEY > >> MBA-HR,B.Com(Hons),BCA > >> Mobile: +91 9810929744 > >> dilipan...@gmail.com > >> dilipan...@yahoo.com > >> New Delhi - 62, India > >> > >> -- > >> > >> > ---------------------------------------------------------------------------------- > >> Some important links for excel users: > >> 1. Follow us on TWITTER for tips tricks and links : > >> http://twitter.com/exceldailytip > >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > >> 3. Excel tutorials at http://www.excel-macros.blogspot.com > >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com > >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > >> > >> To post to this group, send email to excel-macros@googlegroups.com > >> > >> <><><><><><><><><><><><><><><><><><><><><><> > >> HELP US GROW !! > >> > >> We reach over 7000 subscribers worldwide and receive many nice notes > about > >> the learning and support from the group.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. Follow us on TWITTER for tips tricks and links : > > http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials at http://www.excel-macros.blogspot.com > > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > > To post to this group, send email to excel-macros@googlegroups.com > > > > <><><><><><><><><><><><><><><><><><><><><><> > > HELP US GROW !! > > > > We reach over 7000 subscribers worldwide and receive many nice notes > about > > the learning and support from the group.Let friends and co-workers know > they > > can subscribe to group at > > http://groups.google.com/group/excel-macros/subscribe > > > > -- > Sent from my mobile device > > Thanks & Regards, > > DILIP KUMAR PANDEY > MBA-HR,B.Com(Hons),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 62, India > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.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. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
