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.