Excel Macro to Perform Arrange All When Sheet Is ClickedLast reviewed: October 31, 1994Article ID: Q43296 |
SUMMARYThe 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(,"arrange.xlm!R5C1") A3: =RETURN() A4: A5: Arrange_all A6: =ARRANGE.ALL() A7: =RETURN() |
KBCategory: kbother
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |