Making formulas invisible from formula bar

[Guest]

Hiya

I've come across workbooks in the past that have contained locked worksheets. Within these sheets there are some blank cells, and when you populate other cells it will automatically populate the blank cells with the appropriate filling (eg you enter the scores of a football match and a previously blank cell below then displays the name of the winning team)

Now, if I click in this previously blank cell, no formula is visible in the formula bar. There is no VBA code in the workbook, so it isn't populated through VBA. The contents of other cells DO appear in the formula, it appears that only those cells containing formulas make it look as though the cell is totally blank

I am very interested in doing this for some of my work... does anyone know how it is done?

Thanks

Basil

 

[Paul B]

Basil, format, cells, protection and check hidden for the cells you don't
want to see, unlock all the cells you want to put data in and then protect
the sheet
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

Hiya,

I've come across workbooks in the past that have contained locked

worksheets. Within these sheets there are some blank cells, and when you
populate other cells it will automatically populate the blank cells with the
appropriate filling (eg you enter the scores of a football match and a
previously blank cell below then displays the name of the winning team).

Now, if I click in this previously blank cell, no formula is visible in

the formula bar. There is no VBA code in the workbook, so it isn't
populated through VBA. The contents of other cells DO appear in the
formula, it appears that only those cells containing formulas make it look
as though the cell is totally blank.

 

[JulieD]

Hi Basil

it's done through format / cells - protection tab & ticking the hidden check
box

when you protect the sheet (tools / protection / protect sheet) you can not
see the formula in these cells.

hope this helps

Cheers
JulieD

Hiya,

I've come across workbooks in the past that have contained locked

worksheets. Within these sheets there are some blank cells, and when you
populate other cells it will automatically populate the blank cells with the
appropriate filling (eg you enter the scores of a football match and a
previously blank cell below then displays the name of the winning team).

Now, if I click in this previously blank cell, no formula is visible in

the formula bar. There is no VBA code in the workbook, so it isn't
populated through VBA. The contents of other cells DO appear in the
formula, it appears that only those cells containing formulas make it look
as though the cell is totally blank.

 

[Ron de Bruin]

Hi Basil

Select the cells with a formula
Ctrl-1
On the protection tab check hidden also
Protect the sheet

--
Regards Ron de Bruin
http://www.rondebruin.nl

Hiya,

I've come across workbooks in the past that have contained locked worksheets. Within these sheets there are some blank cells, and

when you populate other cells it will automatically populate the blank cells with the appropriate filling (eg you enter the scores
of a football match and a previously blank cell below then displays the name of the winning team).

Now, if I click in this previously blank cell, no formula is visible in the formula bar. There is no VBA code in the workbook, so

it isn't populated through VBA. The contents of other cells DO appear in the formula, it appears that only those cells containing
formulas make it look as though the cell is totally blank.

 

[Ken Wright]

Nice one! So simple, I feel a bit silly.

That answer may well have helped numerous others that didn't want to voice the
question, so don't worry on that score one iota.

I've tried to answer a question lower down in return (never want to take more

than I give).

That kind of attitude will buy you all the help you could want in here, so don't
feel afraid to keep on asking and don't feel afraid to post where you can
either.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

Nice one! So simple, I feel a bit silly.

I've tried to answer a question lower down in return (never want to take more

than I give).