Hide a Formula

  • Thread starter Thread starter bhbjk1
  • Start date Start date
B

bhbjk1

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.
Micky
 
Without sheet protection and/or without VBA I can't think of any way to do
what you want.


Gord Dibben MS Excel MVP
 
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
 
Back
Top