I'm creating a spreadsheet for other users to enter data in and one of the
cells has a formula that I don't want them to see. I've got it to where I
can hide it on the first row but when I tab down to the next row it won't let
me enter any data. Is there a way to hide the formula in that column without
messing up the rest?

To Hide a formula:

- Select the cell(s) with formulas to hide
- Right-Click one of those cells
- Select "Format Cells..."
- Choose the Protection Tab
- Check the "Hidden" and "Locked" boxes
- OK (Note that the formulas will not actually be hidden until the
worksheet is Protected. See below.)

Now to allow other cells to have data entered:

- Select the cell(s) for data entry
- Right-Click one of the cells
- Select "Format Cells..."
- Choose the Protection Tab
- Uncheck the "Hidden" and "Protection" boxes
- OK

Now, Protect your worksheet. On the Review Tab, click the "Protect Sheet"
button.

That should do it.

HTH
Elkar

"Carrie" wrote:

I'm creating a spreadsheet for other users to enter data in and one of the
cells has a formula that I don't want them to see. I've got it to where I
can hide it on the first row but when I tab down to the next row it won't let
me enter any data. Is there a way to hide the formula in that column without
messing up the rest?

Another way is to define it as a name, then hide the name. For example, if
yuor formula is =VLOOKUP(A1,table,2,False) then define a name, like
"MySecretFormula" and have it refer to
=VLOOKUP(A1,Table,2,False)
then in VBA you can use the immediate window to hide the name:
Activeworkbook.names("MySecretFormula").Visible=Fa lse

and from then on use =MySecretFormula instead of the VLOOKUP!

"Carrie" wrote:

I'm creating a spreadsheet for other users to enter data in and one of the
cells has a formula that I don't want them to see. I've got it to where I
can hide it on the first row but when I tab down to the next row it won't let
me enter any data. Is there a way to hide the formula in that column without
messing up the rest?

Hi Bob,
How come if somebody goes to VBA and see the formula?! Is there any way to
hide it in VBA and see it with a password or something?!
Thanx,
peiman

"Bob Umlas, Excel MVP" wrote:

Another way is to define it as a name, then hide the name. For example, if
yuor formula is =VLOOKUP(A1,table,2,False) then define a name, like
"MySecretFormula" and have it refer to
=VLOOKUP(A1,Table,2,False)
then in VBA you can use the immediate window to hide the name:
Activeworkbook.names("MySecretFormula").Visible=Fa lse

and from then on use =MySecretFormula instead of the VLOOKUP!

"Carrie" wrote:

I'm creating a spreadsheet for other users to enter data in and one of the
cells has a formula that I don't want them to see. I've got it to where I
can hide it on the first row but when I tab down to the next row it won't let
me enter any data. Is there a way to hide the formula in that column without
messing up the rest?