If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Hide formulas
Hi, is there a way to hide the formulas in a spreadsheet so they'll only see
the result? thank you |
#2
|
|||
|
|||
Hide formulas
Just google for "hide formulas excel"
there are macro solutions and sheet protection solutions -- Greetings from New Zealand "Heather" wrote in message ... Hi, is there a way to hide the formulas in a spreadsheet so they'll only see the result? thank you |
#3
|
|||
|
|||
Hide formulas
Select the cells to be hidden.
FormatCellsProtection. Checkmark "hidden"........they will be locked also by default. Now ToolsProtectionProtect Sheet. You may want to leave other cells unlocked for editing. First hit CTRL + A to select all cells. Unlock these. Now select the cells to be hidden and locked and do so. Now protect the sheet. Gord Dibben MS Excel MVP On Mon, 24 Aug 2009 13:34:03 -0700, Heather wrote: Hi, is there a way to hide the formulas in a spreadsheet so they'll only see the result? thank you |
#4
|
|||
|
|||
Hide formulas
Just a warning.
Worksheet protection, even with a password, is very weak. A determined user can find ways to see your formulas. Gord On Mon, 24 Aug 2009 14:21:25 -0700, Gord Dibben gorddibbATshawDOTca wrote: Select the cells to be hidden. FormatCellsProtection. Checkmark "hidden"........they will be locked also by default. Now ToolsProtectionProtect Sheet. You may want to leave other cells unlocked for editing. First hit CTRL + A to select all cells. Unlock these. Now select the cells to be hidden and locked and do so. Now protect the sheet. Gord Dibben MS Excel MVP On Mon, 24 Aug 2009 13:34:03 -0700, Heather wrote: Hi, is there a way to hide the formulas in a spreadsheet so they'll only see the result? thank you |
#5
|
|||
|
|||
Hide formulas
thank you, this is very helpful
"Gord Dibben" wrote: Just a warning. Worksheet protection, even with a password, is very weak. A determined user can find ways to see your formulas. Gord On Mon, 24 Aug 2009 14:21:25 -0700, Gord Dibben gorddibbATshawDOTca wrote: Select the cells to be hidden. FormatCellsProtection. Checkmark "hidden"........they will be locked also by default. Now ToolsProtectionProtect Sheet. You may want to leave other cells unlocked for editing. First hit CTRL + A to select all cells. Unlock these. Now select the cells to be hidden and locked and do so. Now protect the sheet. Gord Dibben MS Excel MVP On Mon, 24 Aug 2009 13:34:03 -0700, Heather wrote: Hi, is there a way to hide the formulas in a spreadsheet so they'll only see the result? thank you |
Thread Tools | |
Display Modes | |
|
|