Status Bar not showing up

[andrewb90]

Hello all,

During workbook open, I have several things that happen including going fullscreen. Now I have a line to make the status bar show up, but it doesn't seem to. Is there a happy median to the view that I want?

Private Sub Workbook_Open()Application.OnKey "{F2}", "module5.pophelp"
Application.OnKey "{F4}", "module5.XAB"
'Application.DisplayFullScreen = True
Application.DisplayFormulaBar = False
    ActiveWindow.DisplayHeadings = False
    ActiveWindow.DisplayGridlines = False
Application.DisplayStatusBar = True
Application.OnKey "%{F11}", "module5.nope"
Application.OnKey "{ESC}", "module5.esc"

 

[Michael M]

another option here


Fullscreen with Status Bar using VBA | Chandoo.org Excel Forums - Become Awesome in Excel