Hi, is there a way to hide the formulas in a spreadsheet so they'll only see
the result? thank you

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

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

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

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