|
|
we're glad to help
--
Don Guillett
SalesAid Software
"HT" wrote in message
...
Thank you Don and Rag. :)
"RagDyeR" wrote in message
...
You have the choice to hide the formulas, or delete the formulas,
leaving
the data behind.
If the formulas are hidden, there is always the possibility that the
protection will be by-passed, and the formulas would be viewable.
If the formulas are deleted, there will be no possibility to calculate
or
re-calculate the sheet.
To start either procedure, click in the square to the left of the
ColumnA
header and above the Row 1 label.
This selects the entire sheet.
Then,
TO HIDE:
<Format <Cells <Protection tab,
And make sure "Locked" and "Hidden" are *both* checked.
Then,
<Tools <Protection <ProtectSheet,
Enter a password if you wish, then <OK.
Now, clicking in the cell will *not* reveal the formulas in the
"FormulaBar".
TO DELETE:
After selecting the entire sheet, right click in the selection and
choose
"Copy".
Right click again and choose "PasteSpecial".
Click on "Values", then <OK.
Now, al your formulas are deleted, and the data remains behind
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"HT" wrote in message
...
Excel XP
I have a complicated spreadsheet that has many formulas on it. I only
want
the values of those formulas to appear. I do not want to click in the
cell
and have the formula appear at any time.
Thank you.
|