Hello All,

I have some code that hides the formula bar when a
particular workbook is opened.
(Application.DisplayFormulaBar = False). When the book
is closed, I would like to see the formula bar....I tried
(Application.DisplayFormulaBar = True) in
the "Before_Close" event and it does not seem to
work.....Any ideas??

Thanks

It worked for me.........

Maybe you need to do it <before save as well?

Regards
Bill K


"Tim" wrote in message
...
Hello All,

I have some code that hides the formula bar when a
particular workbook is opened.
(Application.DisplayFormulaBar = False). When the book
is closed, I would like to see the formula bar....I tried
(Application.DisplayFormulaBar = True) in
the "Before_Close" event and it does not seem to
work.....Any ideas??

Thanks