Are the Windows.Arrange ArrangeStyle:=xlHorizontal settings persistent?

  • Thread starter Thread starter Howard Kaikow
  • Start date Start date
H

Howard Kaikow

After creating a workbook, when opened from the GUI, I am noticimg that the
window
is not properly arranged. In particular, I cannot see the tabs at the
bottom.
So I have do the arranging via the GUI, rather annoying.

So I added the following just before save of the workbook.

..Windows.Arrange ArrangeStyle:=xlHorizontal

Thee setting does not hold when opening the workbook.
Anything else I need to set?
 
Howard Kaikow said:
After creating a workbook, when opened from the GUI, I am noticimg that the
window
is not properly arranged. In particular, I cannot see the tabs at the
bottom.
So I have do the arranging via the GUI, rather annoying.

So I added the following just before save of the workbook.

.Windows.Arrange ArrangeStyle:=xlHorizontal

Thee setting does not hold when opening the workbook.
Anything else I need to set?
Click to expand...

Hey Howard, try making the instance of Excel temporarily visible.
 
Howard Kaikow said:
Hey Howard, try making the instance of Excel temporarily visible.
Click to expand...

Thanx Howard, that works!

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

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

Window>Arrange>Tiled - all xls in directory 6
How many sheets open? 5
Worksheets do not open Arranged 4
excel VBA problem - setting workbook as variable & opening/re-opening 1
=hyperlink causes file opening to change window size 6
Grey screen issue - HELP 2
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
Excel 2007 Access the Content Created File property in vba 3

Back
Top