Excel Macro help RRS feed

  • Question

  • I have a macro enabled workbook. I have a macro button to copy the sheet I'm on and create a new one.

    When it copies over to the new sheet, it cuts off the bottom entry from each drop down menu.


    Here is the macro below:

    Sub NewTab()
        ActiveWorkbook.Sheets("Client Template").Copy _
           after:=ActiveWorkbook.Sheets("Client Template")
    End Sub

    Any help would be greatly appreciated.

    Apparently not allowed to post images. :(

    Wednesday, October 9, 2013 3:28 PM


All replies