Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    New Worksheet Behing (97)

    Is there a way to configure Excel to insert new worksheets AFTER the current sheet rather than BEFORE the current sheet? I've look everything I can think of for this setting.
    Ronny Richardson

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: New Worksheet Behing (97)

    No, there is no option for this.

    What you could do is to use the following VBA routine to insert the sheet.

    {pre]
    Public Sub InsertSheet()
    Worksheets.Add After:=ActiveSheet
    End Sub
    [/pre]

    This could be assigned to a button on the tool bar.
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •