title: Excel Macro to Duplicate Sheet, Prompt User to Rename it, and Get Rid of Dropdown Menu
body: <p>As the title says, I am looking for a way to create a macro that can duplicate the sheet the user is on, prompt them to rename it, and in addition, get rid of the drop down menu in cell C4 after a button is pressed. How would I go about doing this? I am very new to VBA and macros and I've only done simple ones through the record macro function, so if you could go into detail or post the code that would be super helpful:)</p>
  
  <p>Here is what I have so far:</p>
  
  <pre><code>Sub rename()
      Dim sName As String
      Dim wks As Worksheet
      Worksheets("Summary").Copy after:=Sheets(Worksheets.Count)
      Set wks = ActiveSheet
      Do While sName &lt;&gt; wks.Name
          sName = Application.InputBox _
            (Prompt:="Enter new worksheet name")
          On Error Resume Next
          wks.Name = sName
          On Error GoTo 0
      Loop
      Set wks = Nothing
  End Sub
  </code></pre>
  
  <p>Thank you for your time!</p>