Dear Ayush,
Thanks .. it is also usefule for me.
But i dont know VBA aslo. If you can breif in detail path then it will
be great help for me.
Thanks in advance.
Regards,
Darshil Shah.
On Thu, Nov 11, 2010 at 8:38 AM, Ashish Jain <26may.1...@gmail.com> wrote:
> Hi Hemant
>
> You can use these VBA methods to solve your problem:
> Sheets(1).Visible = xlSheetHidden 'Hide the worksheet
>
> Sheets(1).Visible = xlSheetVeryHidden 'Hide the worksheet and
> won't be displayed in Unhide Worksheet dialog list
>
> Sheets(1).Protect("Password") 'Replace password with your own
> password
>
> Please modify them as per your need.
>
>
> Please Note: I didn't opened your excel workbook and I suggest
> you to send your problems rather sending workbook as it's a
> dangerous practice.
>
> ________________________________________
> Thanks & Regards
> Ashish Jain
> McKinsey India Knowledge Center
> (Microsoft Certified Application Specialist)
> (Microsoft Certified Professional)
> http://www.excelitems.com
> http://www.openexcel.com
> ________________________________________
>
>
>
> On Sep 14, 2:10 am, hemant shah <hemanthin...@gmail.com> wrote:
>> Hi Team,
>>
>> Please help on the attached.
>>
>> Thanks in advance.
>>
>> Regards,
>> Hemant Shah
>>
>> Hide & Protect the Sheet from other Users.xls
>> 54KViewDownload
>
> --
> ----------------------------------------------------------------------------------
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>
--
Regards,
Darshil Shah.
darshil.m...@gmail.com
+91-9725503879
--
----------------------------------------------------------------------------------
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
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
