Dear Guru
'use case i.e
'user 1 have password1 to change range1
'user 2 have password2 to change range2
'user 3 have password3 to change range3
Case Is = Password1
ProtectCell
UnprotectCell MyRange1
CleanUp
Case Is = Password2
ProtectCell
UnprotectCell MyRange2
CleanUp
Case Is = Password3
ProtectCell
UnprotectCell MyRange3
CleanUp
Hope it Will Help
Happy To Help
:)
Shyam
On Thu, Mar 4, 2010 at 9:49 AM, gurdev singh <gurdevha...@gmail.com> wrote:
> Dear All,
>
> i am also using this type of excel sheet in network mode.
> but i am facing one problem like i have one excel sheet , i protected whole
> sheet except two columns.
>
> Can u please advice how can i give user lever editing right to work e.g.
> one user have only right to open file and second user have to work in Column
> 2 & 4 and third user have right to work in column 6 & 7
>
> One thing more i had protected my sheet with password. but when i have to
> change or update in my excel sheet on cells which are totally protected , i
> have to unprotect sheet and i can make those changes which i needed, but my
> problem is not unprotect the sheet , my problem is :- if i forget to protect
> my sheet with password any one can make changes is that sheet.
>
> is there any alternate , when i close my sheet and next time when any one
> open that sheet still need password to make changes in that.
>
> Dear Experts please advice.
>
> Regards,
>
> Guru
>
>
>
>
> On Thu, Mar 4, 2010 at 12:05 AM, rf1234 rf1234 <rfhyd1...@gmail.com>wrote:
>
>> dear nand
>> ask your admin to built a common share.
>> offcourse it is possible on intranet.now
>> assign the permission who are authenticated
>> person to make change on that workbook.
>>
>>
>>
>> i hope it will help.
>> happy to help
>> :)
>>
>> shyam
>> On Wed, Mar 3, 2010 at 1:51 PM, Dilip Pandey <dilipan...@gmail.com>wrote:
>>
>>> Hi Nand,
>>>
>>> I am not using Excel 2007, so would not be able to explain.
>>> Let someone from "Group" to answer this.
>>> --
>>> Thanks & Regards,
>>>
>>> DILIP KUMAR PANDEY
>>> MBA-HR,B.Com(Hons),BCA
>>> Mobile: +91 9810929744
>>> dilipan...@gmail.com
>>> dilipan...@yahoo.com
>>> New Delhi - 62, India
>>>
>>>
>>> On Wed, Mar 3, 2010 at 10:10 AM, Nandkumar kakvipure <
>>> nandkumar.hindust...@gmail.com> wrote:
>>>
>>>> Hi,
>>>> Pls Tell Me office excel 2007
>>>>
>>>> Thanks in Advance
>>>>
>>>>
>>>>
>>>> On Tue, Mar 2, 2010 at 7:48 PM, Dilip Pandey <dilipan...@gmail.com>wrote:
>>>>
>>>>> Hi Niraj,
>>>>>
>>>>> First Step. Go to Tools->Protection-> Allow users to Edit Ranges. Here
>>>>> you can assign different different ranges to be used by different users
>>>>> and
>>>>> you can also include password, if you wish.
>>>>>
>>>>> Second Step. Now share the spreadsheet with users and share the
>>>>> passwords for different level users.
>>>>>
>>>>> --
>>>>> Thanks & Regards,
>>>>>
>>>>> DILIP KUMAR PANDEY
>>>>> MBA-HR,B.Com(Hons),BCA
>>>>> Mobile: +91 9810929744
>>>>> dilipan...@gmail.com
>>>>> dilipan...@yahoo.com
>>>>> New Delhi - 62, India
>>>>>
>>>>>
>>>>> On Tue, Mar 2, 2010 at 4:35 PM, Niraj Kothari <
>>>>> nirajskoth...@gmail.com> wrote:
>>>>>
>>>>>> Hi,
>>>>>>
>>>>>> I use a excel sheet which uses macro. I want to use this excel sheet
>>>>>> in networking mode with different level of user access to it, so that
>>>>>> data
>>>>>> can be edited from different systems located at different places on the
>>>>>> same
>>>>>> excel sheet. All the systems from which i want to access this excel sheet
>>>>>> have a continuous internet connection.
>>>>>>
>>>>>> Kindly help me in this regard.
>>>>>>
>>>>>> Thanks
>>>>>> Niraj
>>>>>>
>>>>>> --
>>>>>>
>>>>>> ----------------------------------------------------------------------------------
>>>>>> Some important links for excel users:
>>>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>>>> http://twitter.com/exceldailytip
>>>>>> 2. Join our Facebook Group @
>>>>>> http://www.facebook.com/group.php?gid=287779555678
>>>>>> 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 6,800 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
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>>
>>>>> ----------------------------------------------------------------------------------
>>>>> Some important links for excel users:
>>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>>> http://twitter.com/exceldailytip
>>>>> 2. Join our Facebook Group @
>>>>> http://www.facebook.com/group.php?gid=287779555678
>>>>> 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 6,800 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
>>>>>
>>>>
>>>> --
>>>>
>>>> ----------------------------------------------------------------------------------
>>>> Some important links for excel users:
>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>> http://twitter.com/exceldailytip
>>>> 2. Join our Facebook Group @
>>>> http://www.facebook.com/group.php?gid=287779555678
>>>> 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 6,800 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
>>>>
>>>
>>>
>>> --
>>>
>>> ----------------------------------------------------------------------------------
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our Facebook Group @
>>> http://www.facebook.com/group.php?gid=287779555678
>>> 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 6,800 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
>>>
>>
>> --
>>
>> ----------------------------------------------------------------------------------
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our Facebook Group @
>> http://www.facebook.com/group.php?gid=287779555678
>> 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 6,800 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
>>
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 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 6,800 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
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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 6,800 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
