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