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