Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a workbook with currently 11 worksheets. I am wanting to
automatically sort Column A of each worksheet. I have placed the following code within my workbook: Private Sub Workbook_Open() Worksheets("Abs").Select Cells.Select Selection.Sort Key1:=Range("A1"), Order1:=xlAscending, header:=xlyes End Sub :and it works fine but ONLY with the first worksheet becuase it is named ABS. What do i need to put in the code to also sort the other worksheets?? (Sample names of other worksheets...Back, Biceps, Cardio) thanks! LTOSH |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Tracking Instantaneously When the Shared Excel Workbook Is Opened. | Excel Discussion (Misc queries) | |||
sort excel when the workbook is opened | Excel Discussion (Misc queries) | |||
How to stop Excel remembering/loading macro from previously opened Workbook | Excel Discussion (Misc queries) | |||
Is there away to keep Excel from opening a copy of an already opened workbook and the pages not be at 100% but | New Users to Excel | |||
Can a workbook be opened w/out Excel on the host machine?? | Excel Discussion (Misc queries) |