Formula Bar

[Tim]

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

 

[Bill Kuunders]

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

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

Regards
Bill K