Please Help With Function
 

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

Please Help With Function
 

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

Please Help With Function
 

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/

Please Help With Function
 

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/

Please Help With Function
 

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/

Please Help With Function
 

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

Please Help With Function
 

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/

Please Help With Function
 

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

Please Help With Function
 

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.

Please Help With Function
 

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/