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 -- ---------------------------------------------------------------------------------- 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
