When you create a worksheet, sometimes you need to use some formulas, and you don’t want other users to change, edit or delete the formulas. Then click Home Go To Special, and a Go To Special dialog box will appear. And then click Review Protect Sheet, and a Protect Sheet dialog box will pop out, you can enter the password in the Passwordto unprotect sheet box. Then click Highlight Formulas to highlight all formula cells. Select all the highlighted cells and click Selection Lock to lock the formulas.The easiest and most common way of preventing people from playing with your formulas is to lock and protect cells which contain formulas in your worksheet. Check Formulas from Select option, and then click OK. All of the cells which contain formulas will be selected.5. Right click on the selected cells, and choose Format Cells from the context menu, and a Format Cells dialog box will display. And there is a dialog pops out to remind you that the fomulas cannot lock until protect the sheet. Now click Protect Sheet to type the password to protect the sheet. Now the formulas are locked and protected, and you can click Close Design to disable the Design tab.2.Now, to protect the worksheet, choose Tools, Protection, Protect Sheet to bring up the Protect Sheet dialog box. You can enter a password to prevent others from unprotecting the sheet.Locked cells in a protected sheet cannot be edited, and other worksheet changes are disabled.How do I protect the sheet and still have the functionality to group and un-group.I have inserted the following VB code: Sub Enable Outlining()'Update 20140603Dim x Ws As Worksheet Set x Ws = Application.
Value End If End If Next distance = Range(Application. Address)- If distance It works in columns that have empty cells in them.
I've created some clever formulas, and I don't want anyone else to see them.
Is it possible to hide the formulas but display the results?
Normally Excel adjusts the cell references if you copy your formulas to another location in your worksheet.
You would have to fix all cell references with a dollar sign ($) or press F4 key to toggle the relative to absolute references to prevent adjusting the cell references in formula automatically.