A AN Mar 23, 2004 #1 How can you change the default so that a new worksheet inserts AFTER the current one not before (default)?
How can you change the default so that a new worksheet inserts AFTER the current one not before (default)?
J JE McGimpsey Mar 23, 2004 #2 You can't really (it follows the same convention as inserting rows or columns). But you can write your own macro: Public Sub InsertWorksheet() Worksheets.Add After:=ActiveSheet End Sub You could then modify your menu to assign the macro to a toolbar button, a keyboard shortcut, or the insert/worksheet command.
You can't really (it follows the same convention as inserting rows or columns). But you can write your own macro: Public Sub InsertWorksheet() Worksheets.Add After:=ActiveSheet End Sub You could then modify your menu to assign the macro to a toolbar button, a keyboard shortcut, or the insert/worksheet command.
F Falcon Mar 24, 2004 #3 I don't know how to do it in default, but it is easy to change th orders after you create the sheet. Just right click and hold the ta on the bottom of the sheet you want to move and move to where you wan it in the order. To
I don't know how to do it in default, but it is easy to change th orders after you create the sheet. Just right click and hold the ta on the bottom of the sheet you want to move and move to where you wan it in the order. To
