title: How to change the name of the document in Excel?
body: <p>I have a Macro Enabled Template called TIP-PBI.xltm. When I create a document based on this template, Excel automatically names it TIP-PBI1. However, I want to give it a custom name.</p>
  
  <p>I figured I could do that by modifying the .Title property of the Workbook. To that end, on startup the Workbook_Open event kicks off, and the following is executed:</p>
  
  <pre><code>Private Sub Workbook_Open()
      Dim strPBI As String
      strPBI = InputBox$("Enter PBI", "Enter PBI")
  
      ThisWorkbook.Title = "TIP-PBI-" &amp; strPBI
  End Sub
  </code></pre>
  
  <p>However, this does nothing.  </p>
  
  <p>How can I change the Title of the document on startup?</p>