I know how to protect our excel file and worksheet already,
now I would like to allow other people to open and view my file but do not allow them to make another duplicate copy. it's just to protect our effort. as we know, once they can read our file, they can using copy and paste function to make another copy as a new workbook. So how we protect our excel file from duplication?
I assume you don’t want the people you are sending the sheet too to be able to see or copy the formulas.
Select the cells that you wish to protect and click Format, cells and click the Protection tab.
The protect option should be checked and then check the box for Hidden and click OK. Protect the sheet as normal and click on any cell that has a formula in. You will see that the edit bar is blank. If you copy the cell and paste into a new sheet the value will be pasted and not the formula.
Along with the options discussed earlier you should now be able to do what you want
Neil Berryman
IT Trainer
neil_berryman@btopenworld.com
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.