Hiding Formulas, Info Boxes

[arizzy]

Hello folks! It's Aaron the son of Ron is Da Haus. I have a question for all you Excel saavy moguls out there. So hold on to your pants!

First off:
I am dealing with a spreadsheet that has formulas hidden. That is, there is a cell that obviously is controlled by a formula, but when you select it, the formula that is controlling it is not there. Any idea why this is?

Aslo, how do you get those neat info boxes to pop up? Ya know. The ones that contain error messages if you make a mistake. Or the ones that pop up when you select a cell. Any info would be greatly appreciated.

Aaron the son of Ron

[MarkN]

Try http://www.contextures.com/xlDataVal01.html for information on data
validation and how to create the pop up boxes.

To see the formulas:
Select Tools|Protection|Unprotect Sheet.
Select the cells with the formulas.
From the Format menu, select Cells.
Click on the protection tab and take the tick out of Hidden.


--
hope this helps,
MarkN


"arizzy" wrote:

>
> Hello folks! It's Aaron the son of Ron is Da Haus. I have a question for
> all you Excel saavy moguls out there. So hold on to your pants!
>
> First off:
> I am dealing with a spreadsheet that has formulas hidden. That is,
> there is a cell that obviously is controlled by a formula, but when you
> select it, the formula that is controlling it is not there. Any idea why
> this is?
>
> Aslo, how do you get those neat info boxes to pop up? Ya know. The ones
> that contain error messages if you make a mistake. Or the ones that pop
> up when you select a cell. Any info would be greatly appreciated.
>
> Aaron the son of Ron
>
>
> --
> arizzy
> ------------------------------------------------------------------------
> arizzy's Profile: http://www.excelforum.com/member.php...o&userid=34033
> View this thread: http://www.excelforum.com/showthread...hreadid=537947
>
>