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
