Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. -- Jeff |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide a Formula
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide a Formula
Without sheet protection and/or without VBA I can't think of any way to do
what you want. Gord Dibben MS Excel MVP On Tue, 8 Dec 2009 18:03:01 -0800, 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide a Formula
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 "bhbjk1" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to hide a formula | Excel Discussion (Misc queries) | |||
Hide the formula | Excel Discussion (Misc queries) | |||
Protect individual cell and hide formula in formula bar | Excel Worksheet Functions | |||
how to hide formula | Excel Discussion (Misc queries) | |||
Hide formula | New Users to Excel |