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
