software

hi,could anyone tell me how to cover the formula in the column, so that people
unable see what the formula i have put in.

thanks in advance...

Lawrence

Have you tried :
Formatgt;Cellsgt;Protection
Checked: Locked and Hidden

When you protect the sheet, users won't be able to see the formula or change
it.

Does that help?

***********
Regards,
Ronquot;Lawrencequot; wrote:

gt; hi,
gt;
gt;
gt; could anyone tell me how to cover the formula in the column, so that people
gt; unable see what the formula i have put in.
gt;
gt; thanks in advance...
gt;
gt; Lawrence

Ron,

i couldn't find the Locked and hidden... i just able to see the Protection
only...

quot;Ron Coderrequot; wrote:

gt; Have you tried :
gt; Formatgt;Cellsgt;Protection
gt; Checked: Locked and Hidden
gt;
gt; When you protect the sheet, users won't be able to see the formula or change
gt; it.
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt;
gt; quot;Lawrencequot; wrote:
gt;
gt; gt; hi,
gt; gt;
gt; gt;
gt; gt; could anyone tell me how to cover the formula in the column, so that people
gt; gt; unable see what the formula i have put in.
gt; gt;
gt; gt; thanks in advance...
gt; gt;
gt; gt; Lawrence

Hi!

Try this:

Hit CTRL A
Goto Formatgt;Cellsgt;Protection tab
Uncheck Locked
OK

Now, select the cells with the formulas that you want protected.
Goto Formatgt;Cellsgt;Protection tab
Check Locked
Check Hidden
OK

Now, protect the sheet
Goto Toolsgt;Protectiongt;Protect sheet.

Depending on which version of Excel you are using, there are various options
for protection. Choose the ones you want .

Biff

quot;Lawrencequot; gt; wrote in message
...
gt; Ron,
gt;
gt; i couldn't find the Locked and hidden... i just able to see the Protection
gt; only...
gt;
gt; quot;Ron Coderrequot; wrote:
gt;
gt;gt; Have you tried :
gt;gt; Formatgt;Cellsgt;Protection
gt;gt; Checked: Locked and Hidden
gt;gt;
gt;gt; When you protect the sheet, users won't be able to see the formula or
gt;gt; change
gt;gt; it.
gt;gt;
gt;gt; Does that help?
gt;gt;
gt;gt; ***********
gt;gt; Regards,
gt;gt; Ron
gt;gt;
gt;gt;
gt;gt; quot;Lawrencequot; wrote:
gt;gt;
gt;gt; gt; hi,
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; could anyone tell me how to cover the formula in the column, so that
gt;gt; gt; people
gt;gt; gt; unable see what the formula i have put in.
gt;gt; gt;
gt;gt; gt; thanks in advance...
gt;gt; gt;
gt;gt; gt; Lawrence
That would hide the result but the formula would still be visible in the
formula bar.

Regards
Rowan

Desert Piranha wrote:
gt; Lawrence Wrote:
gt;
gt;gt;hi,
gt;gt;
gt;gt;could anyone tell me how to cover the formula in the column, so that
gt;gt;people
gt;gt;unable see what the formula i have put in.
gt;gt;
gt;gt;thanks in advance...
gt;gt;
gt;gt;LawrenceHi Lawrence,
gt;
gt; Another way is custom format the cells with ;;; that is three
gt; semicolons.
gt; Formatgt;Cellsgt;Customgt; key in ;;; click Ok
gt; Then protect the sheet.
gt;
gt;


Hi Rowan,
Yeah, you are correct. The cell still has to be hidden, through
Formatgt;Protectiongt;Hidden.
Sorry for any confusion.
Dave
Rowan Drummond Wrote:
gt; That would hide the result but the formula would still be visible in
gt; the
gt; formula bar.
gt;
gt; Regards
gt; Rowan
gt;
gt; Desert Piranha wrote:
gt; gt; Lawrence Wrote:
gt; gt;
gt; gt;gt;hi,
gt; gt;gt;
gt; gt;gt;could anyone tell me how to cover the formula in the column, so that
gt; gt;gt;people
gt; gt;gt;unable see what the formula i have put in.
gt; gt;gt;
gt; gt;gt;thanks in advance...
gt; gt;gt;
gt; gt;gt;LawrenceHi Lawrence,
gt; gt;
gt; gt; Another way is custom format the cells with ;;; that is three
gt; gt; semicolons.
gt; gt; Formatgt;Cellsgt;Customgt; key in ;;; click Ok
gt; gt; Then protect the sheet.
gt; gt;
gt; gt;--
Desert Piranha------------------------------------------------------------------------
Desert Piranha's Profile: www.excelforum.com/member.php...oamp;userid=28934
View this thread: www.excelforum.com/showthread...hreadid=494038
Lawrence Wrote:
gt; hi,
gt;
gt; could anyone tell me how to cover the formula in the column, so that
gt; people
gt; unable see what the formula i have put in.
gt;
gt; thanks in advance...
gt;
gt; LawrenceHi Lawrence,
Another way is custom format the cells with ;;; that is three
semicolons.
Formatgt;Cellsgt;Customgt; key in ;;; click Ok
Then protect the sheet.--
Desert Piranha------------------------------------------------------------------------
Desert Piranha's Profile: www.excelforum.com/member.php...oamp;userid=28934
View this thread: www.excelforum.com/showthread...hreadid=494038Lawrence

Did you click on the Formatgt;Cellsgt;Protection tab to get a list of options?Gord Dibben Excel MVP

On Thu, 15 Dec 2005 19:16:02 -0800, quot;Lawrencequot;
gt; wrote:

gt;Ron,
gt;
gt;i couldn't find the Locked and hidden... i just able to see the Protection
gt;only...
gt;
gt;quot;Ron Coderrequot; wrote:
gt;
gt;gt; Have you tried :
gt;gt; Formatgt;Cellsgt;Protection
gt;gt; Checked: Locked and Hidden
gt;gt;
gt;gt; When you protect the sheet, users won't be able to see the formula or change
gt;gt; it.
gt;gt;
gt;gt; Does that help?
gt;gt;
gt;gt; ***********
gt;gt; Regards,
gt;gt; Ron
gt;gt;
gt;gt;
gt;gt; quot;Lawrencequot; wrote:
gt;gt;
gt;gt; gt; hi,
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; could anyone tell me how to cover the formula in the column, so that people
gt;gt; gt; unable see what the formula i have put in.
gt;gt; gt;
gt;gt; gt; thanks in advance...
gt;gt; gt;
gt;gt; gt; Lawrence