Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Hondo Chalthoum    on Oct 03 In MS Office Category.

  
Question Answered By: Maurice Hanson   on Oct 03

This is from the macro recorder.

With ActiveWindow
.Width = 274.5
.Height = 352.5
End With
ActiveWindow.NewWindow
With ActiveWindow
.Top = 118.75
.Left = 1.75
End With
Sheets("Sheet2").Select
ActiveWorkbook.Windows.Arrange ArrangeStyle:=xlHorizontal

First I resized the active window  with the mouse.
Then I opened a new window. Window/New Window
Next I resized that one.
Finally I set the windows  to horizontal tiling.

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Code to tile windows horizontally Or get search suggestion and latest updates.


Tagged: