Dear Shivkumar,
Thanks for the honour.
Best Regards,
DILIPandey
On 9/9/10, N.Shivkumar <shiv1...@gmail.com> wrote:
> 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
>
--
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
