Thread: Are the Windows.Arrange ArrangeStyle:=xlHorizontal settings persistent?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Howard Kaikow Howard Kaikow is offline
external usenet poster
  
Posts: 269
Default Are the Windows.Arrange ArrangeStyle:=xlHorizontal settings persistent?
Howard Kaikow" wrote in message
...
Hey Howard, try making the instance of Excel temporarily visible.

Thanx Howard, that works!

With ExcelWbk
appExcel.Visible = vbTrue
.Windows.Arrange
.Save
appExcel.Visible = vbFalse
.Saved = vbTrue
.Close
End With


Reply With QuoteReply With Quote