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
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
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 wrote:
> Hi Nand,
>
> I am no
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,
Hi,
Pls Tell Me office excel 2007
Thanks in Advance
On Tue, Mar 2, 2010 at 7:48 PM, Dilip Pandey 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 p
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
