Excel VBA (DisplayFullscreen and the Windows Toolbar).

  • Thread starter Thread starter jim c.
  • Start date Start date
J

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...
 
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.
 
Back
Top