Hello,

I have a problem. I have a series of cells which display calculate
averages. When the calculations are done, the value is displayed i
those cells. What I want to do is be able to hide the function when
highlight the cell. Now, when I select the result cell, the function i
displayed in the text box at the top of the screen. How do I make is s
that the text box will display the result and not the formula, thanks

--
Message posted from http://www.ExcelForum.com

Don't think you can - You can hide the formula so that nothing appears in the
formula bar, but I don't think you can have just the result show. To hide the
formula, you need to format the cell's protection property as hidden and then
protect the sheet, eg

Format / cells / Protection / Tick Hidden - Now on the sheet do Tools /
Protection / Protect sheet

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"dgmorr " wrote in message
...
Hello,

I have a problem. I have a series of cells which display calculated
averages. When the calculations are done, the value is displayed in
those cells. What I want to do is be able to hide the function when I
highlight the cell. Now, when I select the result cell, the function is
displayed in the text box at the top of the screen. How do I make is so
that the text box will display the result and not the formula, thanks.


---
Message posted from http://www.ExcelForum.com/



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.608 / Virus Database: 388 - Release Date: 03/03/2004

Hi

Menu Format Cells Protection, check Locked and Hidden. Now protect the sheet with menu
Tools Protection Protect worksheet.

You won't be able to enter anything anywhere now -unless you in forehand has unchecked
Locken in the entry cells, same Format menu, before protecting. So do that too.

--
HTH. Best wishes Harald
Followup to newsgroup only please.

"dgmorr " wrote in message
...
Hello,

I have a problem. I have a series of cells which display calculated
averages. When the calculations are done, the value is displayed in
those cells. What I want to do is be able to hide the function when I
highlight the cell. Now, when I select the result cell, the function is
displayed in the text box at the top of the screen. How do I make is so
that the text box will display the result and not the formula, thanks.


---
Message posted from http://www.ExcelForum.com/

if you select the cell, do format=Cell, select the protection tab and
select hidden and locked, then protect the worksheet, the formula will not
appear in the formula bar when the cell is selected.

--
Regards,
Tom Ogilvy

"dgmorr " wrote in message
...
Hello,

I have a problem. I have a series of cells which display calculated
averages. When the calculations are done, the value is displayed in
those cells. What I want to do is be able to hide the function when I
highlight the cell. Now, when I select the result cell, the function is
displayed in the text box at the top of the screen. How do I make is so
that the text box will display the result and not the formula, thanks.


---
Message posted from http://www.ExcelForum.com/

I am half way there. The problem now that I need solved is that I need
to run a macro while it is hidden. When I protect the sheet I cannot
run the macro because it is protected. Any way around this?


---
Message posted from http://www.ExcelForum.com/

What I am doing is copying the result and using paste special to past
it back over. Is there a way I can use VB to Paste Special and past
those resultant values

--
Message posted from http://www.ExcelForum.com

Macros are not protected and will run fine no matter what. In which way do you experience
problems, how do you start the macro ?

--
HTH. Best wishes Harald
Followup to newsgroup only please.

"dgmorr " wrote in message
...
I am half way there. The problem now that I need solved is that I need
to run a macro while it is hidden. When I protect the sheet I cannot
run the macro because it is protected. Any way around this?


---
Message posted from http://www.ExcelForum.com/

The reason I am trying to do this is to reduce the file size. Having al
that extra text from the function creates a much bigger file.

What I do is go to tools/macro/Run Macro. When I put the Protect Shee
mode on, the function will not run

--
Message posted from http://www.ExcelForum.com

What I do is go to tools/macro/Run Macro. When I put the Protect Sheet
mode on, the function will not run.

Ok, if you say so...

Best wishes Harald
Followup to newsgroup only please.

Sub ReduceSize()
ActiveSheet.Unprotect Password:="ABCD"
' perform you actions
ActiveSheet.Protect Password = "ABCD"
End Sub

--
Regards,
Tom Ogilvy

"dgmorr " wrote in message
...
The reason I am trying to do this is to reduce the file size. Having all
that extra text from the function creates a much bigger file.

What I do is go to tools/macro/Run Macro. When I put the Protect Sheet
mode on, the function will not run.


---
Message posted from http://www.ExcelForum.com/