Shri Dilip Pandey has given a very good solution. I generally use the
following code :
Private Sub Worksheet_Activate()
Sheet1.Protect "1823"
Dim pass As String
pass = InputBox("N Shivkumar has for obvious reasons set a Password, kindly
enter password to unprotect sheet")
If pass = "1823" Then
Sheet1.Unprotect "1823"
Else
MsgBox " Incorrect Password"
Worksheets(2).Activate
End If
End Sub
*CARE : **1823 is the password
*
The above code helps in to go to the worksheet but asks for a password
Shri Dilip is a master in excel and he is a mentor to me on a number of
soulutions that he has posted
N.SHIVKUMAR
Mobile : +919422613567
Office : +912332301775
Alternate Email: shiv1...@yahoo.com
On 9 September 2010 11:11, Kal xcel <kalx...@gmail.com> wrote:
> 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
>
--
----------------------------------------------------------------------------------
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
