Hide a Formula



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.



מיכ×ל (מיקי) ×בידן

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.

Gord Dibben

Without sheet protection and/or without VBA I can't think of any way to do
what you want.

Gord Dibben MS Excel MVP



Bob Umlas

Name the formula and use the name. For example, use the name "formula" with
a refers to of =VLOOKUP(...)" (whatever your real formula is), then simply
type =formula in the cell. Be careful of relative/absolute references.
Granted, a knowledgeable user can look at the defined names, but in my
experience there aren't that many really knowledgeable average Excel users!
Bob Umlas
Excel MVP

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question