Do not display information in cells

[JT]

I have a macro where I capture a code and vendor name. I
can change the font to "white", so the user can't see it
displayed in the cell but you can still see what is typed
in the formula bar.

Is there a way to hide what is displayed in the formula
bar without removing the formula?

Thanks for the help......

[Michael Malinsky]

You can go to Tools>Options then under the View tab, uncheck the Formula bar
checkbox.

Programmatically, you can hide the formula bar as follows:

Application.DisplayFormulaBar = False

and restore it by making the above statement True.

"JT" <[email protected]> wrote in message
news:[email protected]...
> I have a macro where I capture a code and vendor name. I
> can change the font to "white", so the user can't see it
> displayed in the cell but you can still see what is typed
> in the formula bar.
>
> Is there a way to hide what is displayed in the formula
> bar without removing the formula?
>
> Thanks for the help......

[Tom Ogilvy]

changed the hidden property to true in the Format=>Cells=>Protection tab and
Protect the worksheet.

or

Put the data in a hidden sheet, protect the workbook structure with a
password (unfortunately easily broken, but no less secure than the above),
and refer to it with your formula.



--
Regards,
Tom Ogilvy


"JT" <[email protected]> wrote in message
news:[email protected]...
> I have a macro where I capture a code and vendor name. I
> can change the font to "white", so the user can't see it
> displayed in the cell but you can still see what is typed
> in the formula bar.
>
> Is there a way to hide what is displayed in the formula
> bar without removing the formula?
>
> Thanks for the help......

[David McRitchie]

to keep the cell itself from displaying you can use the
following as a custom cell format ;;;

You would still need the white background to prevent
viewing in formula view. But it will prevent printing normal
view with B&W setting and from displaying the formula on
the formula bar, you would still need the other things mentioned
by Tom. Nothing if foolproof but it might slow you down the
next time you do maintenance.


"Tom Ogilvy" <[email protected]> wrote...
> changed the hidden property to true in the Format=>Cells=>Protection tab and
> Protect the worksheet.
>
> or
>
> Put the data in a hidden sheet, protect the workbook structure with a
> password (unfortunately easily broken, but no less secure than the above),
> and refer to it with your formula.
>
>
>
> --
> Regards,
> Tom Ogilvy
>
>
> "JT" <[email protected]> wrote in message
> news:[email protected]...
> > I have a macro where I capture a code and vendor name. I
> > can change the font to "white", so the user can't see it
> > displayed in the cell but you can still see what is typed
> > in the formula bar.
> >
> > Is there a way to hide what is displayed in the formula
> > bar without removing the formula?
> >
> > Thanks for the help......
>
>