alam747
asked on
Protect an excel sheet
Hi Experts,
I have an excel workbook with three sheet, I want to protect sheet2 to ( not allow anyone to copy the contents ).
Would you please advice how to do that.
What I want to do is after update the sheet2 of workbook test.xls put the protection. Anyone can open the workbook only the sheet2 can be view but no one can copy or choose the data of any cells of the sheet2 it will ask for password.
Thanks for your prompt response in advace.
I have an excel workbook with three sheet, I want to protect sheet2 to ( not allow anyone to copy the contents ).
Would you please advice how to do that.
What I want to do is after update the sheet2 of workbook test.xls put the protection. Anyone can open the workbook only the sheet2 can be view but no one can copy or choose the data of any cells of the sheet2 it will ask for password.
Thanks for your prompt response in advace.
on the ribbon bar (review) select protect sheet, check the applicable boxes, and add a password.
Be Careful of passwords in corporate environments. If you are away or you leave then it can be very hard to get the document back.
Or if you forget the password then you are stuffed. Or if you do want some people to see it but not others then some have the password and you can assure yourself that they give the password to others.
I would suggest using your companies security policy on a folder that contains that file. have them create 2 security groups one for read and 1 for read write. put you and the other trusted people in read write and all others as read.
this will only stop them editing the file not copying data from it.
Or if you forget the password then you are stuffed. Or if you do want some people to see it but not others then some have the password and you can assure yourself that they give the password to others.
I would suggest using your companies security policy on a folder that contains that file. have them create 2 security groups one for read and 1 for read write. put you and the other trusted people in read write and all others as read.
this will only stop them editing the file not copying data from it.
ASKER
In above way it still allow to choose cells and copy the contents which I do not want to.
It does not allow to change the data of the sheet2 but do not restrict to copy data from any cell, which I am looking for not allow other to choose to copy and paste it to elsewhere.
Please advice.
It does not allow to change the data of the sheet2 but do not restrict to copy data from any cell, which I am looking for not allow other to choose to copy and paste it to elsewhere.
Please advice.
I would say the ultimate best way to do this is with a macro..
something similar to the one here
https://au.answers.yahoo.com/question/index?qid=20100103214412AAxtRD9
a macro is code within excel that governs the worksheet or document.
something similar to the one here
https://au.answers.yahoo.com/question/index?qid=20100103214412AAxtRD9
a macro is code within excel that governs the worksheet or document.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks