I have one workbook which, when opened, I would like to not show the formula
bar - but for this to not affect other workbooks which I may either already
have opened at the same time, or may open once this specific workbook is
open, even if I Ctrl-Tab between them. Is this possible?

Hi drb,

I have one workbook which, when opened, I would like to not show the
formula bar - but for this to not affect other workbooks which I may
either already have opened at the same time, or may open once this
specific workbook is open, even if I Ctrl-Tab between them. Is this
possible?

if your idea is to hide your formulas then you should protect the
sheets of that workbook, first set in the cells-properties to hide the
formulas (something like Format/Cells/Protection activate "hidden" and
"protect" (sorry, translated from german, there are only these 2
options there).

arno

Thanks arno, that's done the trick! One of those simple little features that
I've just never come across before! Cheers

"arno" wrote:

Hi drb,

I have one workbook which, when opened, I would like to not show the
formula bar - but for this to not affect other workbooks which I may
either already have opened at the same time, or may open once this
specific workbook is open, even if I Ctrl-Tab between them. Is this
possible?

if your idea is to hide your formulas then you should protect the
sheets of that workbook, first set in the cells-properties to hide the
formulas (something like Format/Cells/Protection activate "hidden" and
"protect" (sorry, translated from german, there are only these 2
options there).

arno