Hiding Formula

I have a spreadsheet that has 3 pages one is titled "Estimate" one is
"Summary" and the third is a blank worksheet. For security reasons I
want to have all of the formula on the 3rd worksheet but have the input
and results appear on the "Estimate" sheet and the "Summary" sheet.
This way I can hide sheet 3. I do not want any formula on pages 1 & 2.
Can this be done without going to VB. Help!!!!



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

0
10/16/2003 5:36:18 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
306 Views

Similar Articles

[PageSpeed] 38

James,

You can use protection to hide the formulas.  It's not necessary to have the
formulas in another sheet with this approach.  Select cell(s), Format -
Cells - Protection -  Hidden.  You must unlock any cells into which user
change is allowed (Format - Cells - Protection - Unlock) You must also
protect the sheet for this stuff to take effect (Tools - Protection -
Protect sheet).  Use a password when protecting the worksheet.  And (excuse
me for shouting, but there is wailing and gnashing of teeth sometimes over
this one) DON'T LOSE THE PASSWORD!   :)

If you put your formulas in another sheet, they can refer to the cells in
the original sheets (e.g.: =Estimate!B2 - Estimate! C2), and the original
sheet cells (where the formulas would have been) can refer to the formula
sheets (='Formula Sheet'!B2).  But you need to protect this sheet from
prying eyes.  You can hide the sheet but you'll need to prevent them from
unhiding it (Tools - Protection - Protect workbook (not worksheet)).  Use a
password.

Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"James Johnson" <James.Johnson.vekso@excelforum-nospam.com> wrote in message
news:James.Johnson.vekso@excelforum-nospam.com...
> I have a spreadsheet that has 3 pages one is titled "Estimate" one is
> "Summary" and the third is a blank worksheet. For security reasons I
> want to have all of the formula on the 3rd worksheet but have the input
> and results appear on the "Estimate" sheet and the "Summary" sheet.
> This way I can hide sheet 3. I do not want any formula on pages 1 & 2.
> Can this be done without going to VB. Help!!!!
>
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~ View and post usenet messages directly from http://www.ExcelForum.com/
>


0
nowhere8060 (363)
10/16/2003 6:04:43 PM
Reply:

Similar Artilces:

Hide Chart Formulas
Is there any way to hide the chart series formula that displays when you click on a data point on a chart? Thanks, Wayne C. I imagine you could hide the formula bar (Tools | Options... | View tab. -- Regards, Tushar Mehta http://www.tushar-mehta.com Custom business solutions leveraging a multi-disciplinary approach "Wayne Cressman" wrote: > Is there any way to hide the chart series formula that displays when you > click on a data point on a chart? > > Thanks, > Wayne C. > True but that's not my issue. If you click on the datapoint the formula appea...

Formula to return numerical, text result?
I need to create a formula that based upon three possible factors, wil return one of two calculations or a text message. If cell B="Good", the formula in cell C returns "Text" If cell B="Better", the formula in cell C returns cell A*.3 If cell B="Best", the formula in cell C returns cell A*.5 Thanks in advance for any tips -- burgeo ----------------------------------------------------------------------- burgeon's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2023 View this thread: http://www.excelforum.com/showthread.php...

Formulas #4
Where would be the best place to start looking at different formulas used in excel. I have a series of arguments etc that I need to work out but currently only have basic knowledge. Is there a site someone could please put me onto? I have been chucked in the deep end with a staff member leaving who has designed an excel program that formulates quotes for our business. Any ideas? Thanks Kassie Hi Kassie! No need to post to more than one group. Reply down the road at New Users was: You could look at: Peter Noneley http://homepage.ntlworld.com/noneley/ Also if you apply direct to me you...

help with formula please
This is for scoring duplicate bridge essentially this: Have five scores 1 40 1.5 2 100 3 3 40 1.5 4 400 4 5 -60 0 Want to award points from 0 to 4 as shown. given second, what would a formula be in each cell of the third column that would produce the score? ties are common and scores are given to 1 dec place by halves. I have pretty much got nowhere with this so far. Thanks for any help John On Fri, 14 May 2010 17:47:50 -0500, John <john6528@comcast.com> wrote: >This is for scoring duplicate bridge &...

Using contents of a cell in a formula
Hi, I'm trying to use the contents of a cell (as opposed to the actual cell) in a Formula. For example – in the following Statement: =AVERAGE(IF((PRICES!D$32848:D$34120=A44),PRICES!P$32848:P$34120)) Instead of using ‘PRICES!D$32848:D$34120’, I want to use the contents of another cell – lets say Cell A2’ Cell A2 would contain the character expression ‘PRICES!D$32848:D$34120’ So the statement above would read something like: =AVERAGE(IF((? A2 ?),PRICES!P$32848:P$34120)) How do I get the statement above to recognize the contents of cell A2 instead of cell A2? I know I could create ...

Shortcut to get into formula bar
Hi, Does anyone know if there is something I can type on the keyboard in order to get my cursor into the formula bar? Sometimes having to use the mouse is a little inconvenient. Thanks Press F2 -- Rgds Max xl 97 ---------------------------------- Use xdemechanik <at>yahoo<dot>com for email ----------------------------------------- "Jesse" <jesse@multidataservices.com> wrote in message news:E44555FF-D908-4773-9F53-BEA2CEBEF675@microsoft.com... > Hi, > > Does anyone know if there is something I can type on the keyboard in order to get my cursor into the ...

hide worksheet
is there any way to hide worksheets in a workfile for eg - i have to hide 5 to 8 worksheet in a workfile consisting of 10 worksheet. "Ankur" <Ankur@discussions.microsoft.com> wrote in message news:92DF8CAD-28F9-4161-B9C6-2214DF041294@microsoft.com... > is there any way to hide worksheets in a workfile for eg - i have to hide > 5 > to 8 worksheet in a workfile consisting of 10 worksheet. Yes, there is, and it's simple & clearly labeled. Explore the Excel menus until you find the word "Hide". Or, press F1 for the Help system and search for the w...

Named Range in a External File Formula
I have a simple VBA program that when run, looks at a date in a particular cell and updates 6 named ranges with specific file names it uses based off of that days date. I have a folder for every day of the week and inside there are 6 exactly named files: "Tech Name - Service Log - Date.xls" (Date is in mm-dd-yyyy format) The named ranges are "TechName1File, TechName2File, ect...." How do I make this work: After successfully running the macro to fill the named ranges, the named ranges will look like this: Named Range: TechName1File = \\Server\Folder\Folder\<Year>\...

how to hide an ActiveX control?
hi there i have an ActiveX control, written in C++, which has the OLEMISC_INVISIBLEATRUNTIME flag set, yet when i display the web page it is attached to, i get the familiar "red cross" graphic in the middle of the screen - how can i hide the control so nothing is displayed at all? tia bhu can u set the size of ur control as 1x1 pixels "bhu Boue vidya" <bhuvidya@yahoo.com.au> wrote in message news:1175703214.292931.252210@e65g2000hsc.googlegroups.com... > > hi there > > i have an ActiveX control, written in C++, which has the > OLEMISC_INVISIBLEATR...

RECEIPTS: Hide up item look up code in receipt
My buyer and I are wondering, how would you change the receipt to hide/not show the item lookup code in the receipt. Any help would be appreciated. Sincerely, Ryan hi Ryan, its very easy to do so, make a backup of receipt.xml file under: C:\Program Files\Microsoft Retail Management System\Store Operations\ReceiptTemplates or whereever you installed the program. Then open the receipt.xml file in notepad and find the "Entry.Item.ItemLookupCode" and just cut from whole code whereever it appears and then save the file. then again to to SO Manager program> Database > Regi...

Extending Excel with more formulas
Subject: Extending Excel with more formulas Hi, Is there a way to extend Excel foruma base to include more formulas? Thanks, DDUP. Yes, by writing UDFs (User Defined Functions) either within VBA or an add-in. -- Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy - "death" <death@SupportX.com> wrote in message news:0A2C35B44976@123456789.spx.com... > Subject: Extending Excel with more formulas > > Hi, > > Is there a way to extend Excel foruma base to include more formulas? > > Thanks, > > DDUP. > > death wrote: &...

Apply concatenation formula to column
Ho campers An extremely basic question: I have figured out how to concatenate several values from a particular row (e.g. =F2&"."&G2) to get what I need in H2. How do I then apply the same formula for the entire F and G columns to show the results of each row in it's respective M row? I assume I can do this without writing a new formula in M for each row, but I've been trying various search phrases in Excel help without success. (Good thing I at least remembered "concatenate" is what I wanted to do... . Hope that makes sense. Thanks for any help Georg Wi...

Cell reference in formula as range
I have a formula in my spreadsheet that looks like: =IF(D11=0," ",IF(C11<D11,"Not Enough Hours",INDEX('PF Kintanas Pivot Tables'!$A$403:$A$418,MATCH($D11,t(E1),-1)))) In cell E1 I have the following text: gtalbo In the PF Kintanas Pivot Tables tab I have a named range with the name: gtalbo When I try to use the above formula I get the #Value! error. If I substitute the actual name of the range in the formula it works: =IF(D11=0," ",IF(C11<D11,"Not Enough Hours",INDEX('PF Kintanas Pivot Tables'!$A$403:$A$418,MATCH...

Hide account?
Hello all, Is it possible to have an account be open, and still have it hidden in the account list? If so how? Thanks, Confused Man No. Open = visible in account list. "Shhh" <1321564@3215348.com> wrote in message news:tNadncFAN_IC9BTfRVn-hA@adelphia.com... > Is it possible to have an account be open, and still have it hidden in the > account list? If so how? ...

Formula Error.. help !
=OFFSET(MATCH(i2,sheet2!$i:$i,0),1,-3) is giving me an error... I cant see why.. Rich, Look up OFFSET in help, you seem to be using it incorrectly. The arguments are OFFSET(reference,rows,cols,height,width) Reference is the reference from which you want to base the offset. Reference must be a reference to a cell or range of adjacent cells; otherwise, OFFSET returns the #VALUE! error value. Rows is the number of rows, up or down, that you want the upper-left cell to refer to. Using 5 as the rows argument specifies that the upper-left cell in the reference is five rows below refere...

Simple formula
Hi, I'm a new to Excel so please excuse my ignorance in advance. I have data in Column C that I need to multiply with Column D. I know (for example) I can get a result by placing the formula: =sum(C3*D3) in cell E3. But, I have very long columns of data and I don't want to type in =sum(C4*D4)in cell E4, =sum(C5*D5) in cell E5 etc. My question is; can I use a wildcard for the column number and then just paste this formula in each E cell? Thanks On Fri, 22 Jul 2005 14:02:51 +0100, PigPOg <simon@capella.co.uk> wrote: >Hi, I'm a new to Excel so please excuse my ignoranc...

* Need serious help with formula/function *
Here's an example of what I need... Cell Value _________________ D3 100.0000 <---------------- Random number entered D7 37.6875 D8 75.3750 <---------------- 100.0000 falls D9 113.0625 in between here. D10 150.75000 D11 188.4375 D12 226.1250 D19 _________ <---------------- Target number I need excel to recognize where the random number ( D3 ) falls on the s...

how to make a formula to be "&"s formula
hi, could anybody tell me something about the way to make a formula to be "&"s formula. i mean that, for instance ,make =D22-G28-D26 to be =D22&" $B!](B "&G28&" $B!](B "&D26, for i like the show the detail of the formula,instead of the result. thanks best regards Dnia Wed, 17 Nov 2004 21:47:43 +0900, EXCEL NEWS napisał(a): > hi, > could anybody tell me something about the way to make a formula to be "&"s > formula. > i mean that, for instance ,make =D22-G28-D26 to be =D22&" − "&G28&&q...

Formulas not calculating correctly
How do I get formulas to calculate correctly? I have used the following simple formula - =T20*Z20 where t20 = =IF(N20>100%,"0",K20-M20) z20 = 917,000 n20 = 99.04% k20=394 m20=390 When I do the math, it should total 3,668,000, yet my total in excel is 3,457,090. Why is excel calculating this incorrectly? Hi I think its rounding problem if type figures given into excel it calculates 3668000 I presume figures in row 20 are sums of ranges Tina "MWickline" wrote: > How do I get formulas to calculate correctly? > > I have used the following simple formula...

Remove characters from a text string using a formula
I need a formula where I can remove characters such as . - space or _. These characters can show up anywhere in the text string. i.e., 123-abc should be 123abc 123 abc should be 123abc any help would be greatly appreciated, Regards, Robert Hi! Try this to remove periods(or decimal points), dashes(-), spaces, and underscores( _ ) =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,".",""),"-","")," ",""),"_","") Biff "duncrbrt" <duncrbrt@discussions.microsoft.com> wrote in message news:8CAF...

WHATS THE FORMULA FOR Daily log of calories and fat percentage
...

What's wrong with my array formula
In A1 I have 100 200 300 400 500 600 700 800 900 1000 1100 1200 1300 1400 1500 1600 1700 1800 1900 2000 2100 2200 2300 2400 2500 In D1 I have 200 400 600 800 1000 1200 1400 1600 1800 2000 2200 2400 In E1 I have A B C D E F G H I J K L I want to match the value in Col A with Col B and were equal copy from Col E that is next to the matching value in Col D to Col B next to the matching value in Col A. Did that make any sense?? Here what I'd hope for where the numbers are column A and the letters are in column B. 100 200 A 300 400 B 500 600 C 700 800 D 900 1000 E 1100 1200 F 1300 1...

Formula with to Criteria
Hi, I have a row of numbers in Coloumn B ranging from 1 to 200 what I want is a formula in cell A1 that will do the folowing. Look at my range in coloumn b for example B1:B200 and countif the number is the coloumn is over 25 >25 and below 100 <100. I can do countif functions but don't know who to do the above or below part. Any help would be apperciated Thanks =COUNTIF(B1:B200,">25")-COUNTIF(B1:B200,">=100") OR =SUMPRODUCT(--(B1:B200>25),--(B1:B200,>=100)) OR, in Excel2007+ only =COUNTIFS(B1:B200,">25",B1:B200,"&g...

Cell displays wrong total after copying formula
Sometimes, when I copy a formula (usually the sum of a range) to another cell, instead of getting the sum of the new cells, I get the sum of the old cells. The formula is not set to absolute. For example, I copied the forumula =SUM(D6:D9) from cell D11 to cell C11. The formula in C11 is now =SUM(C6:C9). But, instead of calculating C:6:C9, the cell is displays the total from the D column. Has anyone else encountered this problem? Does anyone know if this is an issue with Excel? (This issue is difficult to search for.) Make sure Calculation is set to Automatic (Tools/Options/Calculation....

What formula do I use to calculate compound annual growth rate (C.
...