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 :
FormatCellsProtection
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,
Ron


"Lawrence" wrote:

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

Ron,

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

"Ron Coderre" wrote:

Have you tried :
FormatCellsProtection
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,
Ron


"Lawrence" wrote:

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

Hi!

Try this:

Hit CTRL A
Goto FormatCellsProtection tab
Uncheck Locked
OK

Now, select the cells with the formulas that you want protected.
Goto FormatCellsProtection tab
Check Locked
Check Hidden
OK

Now, protect the sheet
Goto ToolsProtectionProtect sheet.

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

Biff

"Lawrence" wrote in message
...
Ron,

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

"Ron Coderre" wrote:

Have you tried :
FormatCellsProtection
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,
Ron


"Lawrence" wrote:

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

That would hide the result but the formula would still be visible in the
formula bar.

Regards
Rowan

Desert Piranha wrote:
Lawrence Wrote:

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...

LawrenceHi Lawrence,

Another way is custom format the cells with ;;; that is three
semicolons.
FormatCellsCustom key in ;;; click Ok
Then protect the sheet.

Hi Rowan,
Yeah, you are correct. The cell still has to be hidden, through
FormatProtectionHidden.
Sorry for any confusion.
Dave
Rowan Drummond Wrote:
That would hide the result but the formula would still be visible in
the
formula bar.

Regards
Rowan

Desert Piranha wrote:
Lawrence Wrote:

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...

LawrenceHi Lawrence,

Another way is custom format the cells with ;;; that is three
semicolons.
FormatCellsCustom key in ;;; click Ok
Then protect the sheet.




--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=494038

Lawrence Wrote:
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...

LawrenceHi Lawrence,
Another way is custom format the cells with ;;; that is three
semicolons.
FormatCellsCustom key in ;;; click Ok
Then protect the sheet.


--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=494038

Lawrence

Did you click on the FormatCellsProtection tab to get a list of options?


Gord Dibben Excel MVP

On Thu, 15 Dec 2005 19:16:02 -0800, "Lawrence"
wrote:

Ron,

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

"Ron Coderre" wrote:

Have you tried :
FormatCellsProtection
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,
Ron


"Lawrence" wrote:

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