Hello all,
I am working on a document and in the document, there are specific cells, rows and columns that I do not want users to temper with the formulas. Your help will be highly appreciated.
Kindest Regards,
Daotor.
Hello all,
I am working on a document and in the document, there are specific cells, rows and columns that I do not want users to temper with the formulas. Your help will be highly appreciated.
Kindest Regards,
Daotor.
By default all cells in a worksheet are locked. If you set sheetprotection on, nobody will be able to make changes to any locked cells and thus not temper with your formulas.
In the ribbon on the Cells tab select Format and select "Protect sheet". You can then enter a password (if you like) and select what people can do on your sheet.
Do not forget to unlock any cells people need to input data in.
Cheers!
Tsjallie
--------
If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!
If you think design is an expensive waste of time, try doing without ...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks