View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default Maximized Workbook

Run this and see if it helps:

Sub restoreXL()
With Application
.DisplayFullScreen = False
.DisplayFormulaBar = True
.DisplayStatusBar = True
End With
With ActiveWindow 'This with statement sets everything to normal
.WindowState.xlMaximized
.DisplayHorizontalScrollBar = True
.DisplayVerticalScrollBar = True
.DisplayWorkbookTabs = True
.DisplayHeadings = True
.DisplayGridlines = True
End With
End Sub





"Stephen Newman" wrote:

I have a workbook with several macros I've been modifying for years. I
created it using XL2003. It works perfectly with that version of XL,
however, the company I work for uses XL2000. I don't know what I've
done to make the workbook minimize/maximize/close buttons disappear,
but they have. The workbook opens fine in XL2000, but it does not
expand to fill the XL program container. It sits unmovable on the left
side without any buttons. It won't even scroll. I know I did something
years ago that did that thinking I'd always use XL2003....but I was
mistaken.

Is there a way I can restore the buttons, or at least maximize it to
fit the application?