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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How detect if any workbooks are open? 3
Centralizing a command button on a userform 8
print preview 3
Position Userform In Cells Portion of Excel Only 1
userform to appear in the center of the screen 3
Hide worksheet changes when userform displayed 2
Center Userform Controls 4
Setting the page index in a mulipage user form 2

Back
Top