Hi Dilip
i tried your code its working well, but if anybody press ALT + F 8 any
body get some macro code is there i solved it in this way is there any
better way for this
Sub unhidesheet()
If Application.InputBox("ENTER PASSWORD") = "123" Then
Sheet1.Visible = xlSheetVisible
Else
Sheets("hide").Visible = True
End If
End Sub
Regards
Rajesh Kainikkara
On 11/25/10, Dilip Pandey <dilipan...@gmail.com> wrote:
> Hi Rajesh,
>
> You can use following code:-
>
> Sheet1.Visible = xlSheetVeryHidden
> Or
> Sheets("Sales").Visible = xlSheetVeryHidden
>
> Now, you can not see it using Format->Sheet-> unhide
> To get it, use following code
>
> Sheet1.Visible = True
>
> Further to this, you can protect your VBA code as well, so that no one
> can edit the code to unhide the sheets.
>
>
> Best Regards,
> DILIPandey
>
>
> On 11/24/10, Rajesh K R <rajeshkainikk...@gmail.com> wrote:
>> what i need is that i have many files in my computer each having a
>> many worksheets
>> among this many of the sheets contain datas which is not allowed
>> others to access
>> if i am simply hide a sheet or range they will understand that some
>> sheets or data is hided here .i want to over come this. normaly nobody
>> should not find some data is protected viewing in tools menu.
>>
>> Regards&Thanks
>> Rajesh kainikkara
>>
>> On 11/23/10, Dilip Pandey <dilipan...@gmail.com> wrote:
>>> Hi Rajesh,
>>>
>>> If you are talking in terms of Excel, then use the following path:-
>>> Tools -> Protection->Allow users to Edit Ranges
>>>
>>> In this you can have different passwords for different ranges.
>>> Additionally you can also show or hide sheets and protect and
>>> un-protect them using passwords. Workbook passwords or Macros can be
>>> used to achieve this.
>>>
>>> Feel free to get back in case you need further help.
>>>
>>> Best Regards,
>>> DILIPandey
>>>
>>>
>>>
>>> On 11/22/10, Rajesh K R <rajeshkainikk...@gmail.com> wrote:
>>>> Hi Experts
>>>> is it possible to make file which having hided and unguided sheets and
>>>> open them using different passwords.
>>>> Regards
>>>> Rajesh kainikkara
>>>>
>>>> --
>>>> ----------------------------------------------------------------------------------
>>>> 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
>>>>
>>>
>>>
>>> --
>>> 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
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>>
>>
>> --
>> ----------------------------------------------------------------------------------
>> 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
>>
>
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>
--
----------------------------------------------------------------------------------
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
