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
