title: Disabling Workbook Connections
body: <p>I have an Excel 2007 .xltm workbook template with several connections to SQL Server.  I did not list the xltm's directory as a Trusted Location, so by default, external connections were disabled.  This works well, because I have macros (signed &amp; trusted) that would later enable these connections after a series of inputs using <code>Workbook_Open</code>.</p>
  
  <p>However, I recently added the directory as a trusted location, and now the connections refresh automatically (regardless of <code>Connection.ODBCConnection.RefreshOnFileOpen</code> being set to <code>False</code>..)</p>
  
  <p>So, I was hoping to find a simple command such as <code>ActiveWorkbook.DisableConnections</code> (since there is an <code>ActiveWorkbook.EnableConnections</code>...)</p>
  
  <p>All I see is the read-only <code>ActiveWorkbook.ConnectionsDisabled</code>... How do I set it to true?</p>