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
