Insert worksheet AFTER current?

  • Thread starter Thread starter AN
  • Start date Start date
A

AN

How can you change the default so that a new worksheet
inserts AFTER the current one not before (default)?
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert a new Worksheet AFTER the existing (Active) sheet 1
ADD (not insert) worksheets into an already exiting document 6
VBA - retrieve data on last create named range from previous inserted named range 0
Function Arguments dialog vanishes when clicked an inserted shape 2
Excel-Adding rows to master sheet that will be inserted on following worksheets 1
How do I insert new work sheets in numerical sequence? 2
Absolute References and worksheets 0
Problems With Custom Worksheets 1

Back
Top