Hi,
Anyone can press Alt+F11 to go to visual basic editor but if the vba
project is password protected then they wld not be able to see the
code.
Your way is also good.
Best Regards,
DILIPandey
On 11/27/10, Rajesh K R <rajeshkainikk...@gmail.com> wrote:
> 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
>
--
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
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
