Excel VBA (DisplayFullscreen and the Windows Toolbar).

[jim c.]

this is what I use to maximize userform... maybe something
here you can use
***********************************************************
Sub ShowAppSize()
Application.WindowState = xlMaximized
appWidth = Application.Width
appHeight = Application.Height
With UserForm1
.Height = appHeight
.Width = appWidth
End With
End Sub

***********************************************************

hope this helps...

 

[Chris Underwood]

I'm not using any forms, I'm just using spreadsheets to display data.
If excel is set to fullscreen mode the windows toolbar covers the
bottom portion of excel.