Excel Query

[JoanneB]

Hi? In an excel spreadheet is there anyway of hiding the contents of the formula bar, so that if a person clicks on a cell they can't view how a formula has been worked out? Many Thanks

[nykkieberry]

welcome to answerbank Jo!

[darth vader]

right-click on the cell(s) highlighted and select "format cells" and the "protection" tab and tick the "hidden" box. select OK. The sheet (and cells you chose as hidden) are still viewable until you select from the toolbar "Tools", "protection", "protect worksheet" - at which point you can set a password. Now the cell formula is hidden! - you can disable protection through tools, protection, un-protect worksheet (and entering the password). PS welcome from Darth also......

[Hippy]

You can also try, from the Menu Bar ...

Tools ... Options ... then un-tick the "Formula Bar" box.

When applied, this will hide it until restored by the opposite action. You can make a macro to run on stratup to do this to the Excel user interface every time the spreadsheet is loaded. (This will affect other users loading your spreaedsheet) And to be kind, you undo it before closing the Spreadsheet afterwards.

[TEAK36]

Its been a while since I used Excel,but I seem to recall that it is difficult to completey protect a worksheet because if a person copied the whole spreadsheet into another workbook,then the protected cells become visible once again.

[JoanneB]

Just wanted to say, thanks for your answers!! You've been a great help! Cheers Jo