Microsoft KB Archive/43296

-

{| 2.00 2.01 2.10 3.00 | 2.20 2.21 3.00 WINDOWS            | OS/2
 * width="100%"|

SUMMARY
The following macro performs the Arrange All command whenever another sheet is activated. When working with an odd number of sheets, it will make the active sheet the largest. The macro is assumed to be named ARRANGE.XLM.

A1: Arrange A2: =ON.WINDOW(,&quot;arrange.xlm!R5C1&quot;) A3: =RETURN A4: A5: Arrange_all A6: =ARRANGE.ALL A7: =RETURN
 * }

-

Last reviewed: November 2, 1994

© 1998 Microsoft Corporation. All rights reserved. Terms of Use.