Without Protecting the sheet cells - the only idea I can come up with is to
use TWO Sheets.
In the FIRST put your formulas and calculations and make the SECOND Sheet to
be a "reflection" of the FIRST Sheet but as such it will display values only.
In fact - The second sheet linked cells will display only the results and
not the formulas themselves.
Now, you'll need to push [Alt+F11] and hide the FIRST sheet through its
XlSheetVeryHidden property.
To prevent other users - except the file owner - to unhide the FIRST Sheet,
property You need to protect the VBA Project with a password.
Micky


"bhbjk1" wrote:

I am creating a spreadsheet that has formulas I do not want people to see.
This spreadsheet has outlines and groups.

How can I hide the formulas without protecting the sheets and still show the
formula bar.

The people I am sending the file to are not Excel literate enough to reset a
macro when they open the file, so it needs to open with no problems.
--
Jeff