ChatterBank2 mins ago
Excel Query
5 Answers
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
Answers
1 to 5 of 5
Best Answer
No best answer has yet been selected by JoanneB. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.
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......
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.
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.
1 to 5 of 5
