I'm trying to hide the formula in for two columns in a worksheet. But
when I go to protect the sheet, the formatting abilities on all cells
are grayed-out. Is there a way to just hide the formula in a cell
without affecting the rest of the worksheet in anyway?

Custom Format
;;;

"Matt" wrote:

I'm trying to hide the formula in for two columns in a worksheet. But
when I go to protect the sheet, the formatting abilities on all cells
are grayed-out. Is there a way to just hide the formula in a cell
without affecting the rest of the worksheet in anyway?

I'm not sure what that means


Teethless mama wrote:
Custom Format
;;;

"Matt" wrote:

I'm trying to hide the formula in for two columns in a worksheet. But
when I go to protect the sheet, the formatting abilities on all cells
are grayed-out. Is there a way to just hide the formula in a cell
without affecting the rest of the worksheet in anyway?

Matt

Custom format to ;;; is a method of making the cell contents look blank but
unfortunately still allows users to see the formula in the formula bar.

If using version 2002 or 2003 you can lock the cells with the formulas and set
them to hidden while still leaving other cells available for data entry and
formatting.

By default all cells are locked when the sheet is protected.

Hit CRTL + A(twice if xl2003) then FormatCellsProtection. Uncheck "locked"
and OK.

Select the cells you wish to lock and FormatCellsProtection. Check "locked"
and "Hidden" and OK

Now ToolsProtectionProtect Sheet. This is mandatory.

You can set a password to unprotect the sheet. These can easily be broken in
Excel but will keep your formulas from being accidentally overwritten.

NOTE the options available in xl2002 and 2003 when you hit Protect Sheet


Gord Dibben Excel MVP

On 21 Dec 2006 11:29:23 -0800, "Matt" wrote:

I'm not sure what that means


Teethless mama wrote:
Custom Format
;;;

"Matt" wrote:

I'm trying to hide the formula in for two columns in a worksheet. But
when I go to protect the sheet, the formatting abilities on all cells
are grayed-out. Is there a way to just hide the formula in a cell
without affecting the rest of the worksheet in anyway?



Gord Dibben MS Excel MVP