Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Run VBA sort when I open worksheet
I've looked all around this wonderful web and I can't find anything on
executing VBA code when a specific worksheet is opened. There's plenty on opening the workBOOK but I don't need that. What I'd like to do is have a sheet automatically sort itself when it's opened. Sheet name: "Half Payout" or "Sheet2" sorting code: Range("B3:J99").sort Key1:=Range("D3"), Order1:=xlAscending, Key2:=Range( _ "F3"), Order2:=xlAscending, Key3:=Range("B3"), Order3:=xlAscending, _ Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:= _ xlTopToBottom, DataOption1:=xlSortNormal, DataOption2:=xlSortNormal, _ DataOption3:=xlSortNormal Thanks for any help on this. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Run VBA sort when I open worksheet
Private Sub Worksheet_Activate()
' put your code here End Sub Put this in the worksheet code area. -- Gary''s Student - gsnu200839 "JSnow" wrote: I've looked all around this wonderful web and I can't find anything on executing VBA code when a specific worksheet is opened. There's plenty on opening the workBOOK but I don't need that. What I'd like to do is have a sheet automatically sort itself when it's opened. Sheet name: "Half Payout" or "Sheet2" sorting code: Range("B3:J99").sort Key1:=Range("D3"), Order1:=xlAscending, Key2:=Range( _ "F3"), Order2:=xlAscending, Key3:=Range("B3"), Order3:=xlAscending, _ Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:= _ xlTopToBottom, DataOption1:=xlSortNormal, DataOption2:=xlSortNormal, _ DataOption3:=xlSortNormal Thanks for any help on this. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Run VBA sort when I open worksheet
Thanks, GS! I knew it would be something simple like that.
"Gary''s Student" wrote: Private Sub Worksheet_Activate() ' put your code here End Sub Put this in the worksheet code area. -- Gary''s Student - gsnu200839 "JSnow" wrote: I've looked all around this wonderful web and I can't find anything on executing VBA code when a specific worksheet is opened. There's plenty on opening the workBOOK but I don't need that. What I'd like to do is have a sheet automatically sort itself when it's opened. Sheet name: "Half Payout" or "Sheet2" sorting code: Range("B3:J99").sort Key1:=Range("D3"), Order1:=xlAscending, Key2:=Range( _ "F3"), Order2:=xlAscending, Key3:=Range("B3"), Order3:=xlAscending, _ Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:= _ xlTopToBottom, DataOption1:=xlSortNormal, DataOption2:=xlSortNormal, _ DataOption3:=xlSortNormal Thanks for any help on this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open File menu sort alphabetical. | Excel Discussion (Misc queries) | |||
How do I get a blank worksheet to open up when I open Excel? | Setting up and Configuration of Excel | |||
'Save current worksheet'; 'Open next worksheet' - two command buttons | Excel Discussion (Misc queries) | |||
Sort order in File Open dialogue box | Excel Discussion (Misc queries) | |||
How do I get my personal macro worksheet to open whenever I open . | Excel Discussion (Misc queries) |