title: Detect the type of Selection in a Worksheet just deactivated, in any open Workbook
body: <p>I want a method to inquire, after changing the <code>ActiveSheet</code> (<strong>EDIT: of any open <code>Workbook</code></strong>):</p>
  
  <ol>
  <li>Detect the type of <code>Selection</code> in the previous active sheet (of most importance, if it was a <code>ChartObject</code> or <code>Range</code>).</li>
  <li>If it is a <code>Range</code>, get the address.</li>
  </ol>
  
  <p>Is this possible ...?</p>
  
  <p><strong>EDIT</strong>: ... (cont.)</p>
  
  <ol>
  <li>Without additional Activating/Deactivating to inquire (preferred).</li>
  <li>With additional Activating/Deactivating to inquire.</li>
  </ol>
  
  <p>Note that adding code to <code>ThisWorkbook</code> only affects that Workbook.
  So, I guess that something like what Jon Peltier posted for Chart events may work (<a href="http://peltiertech.com/chart-events-microsoft-excel/" rel="nofollow noreferrer">http://peltiertech.com/chart-events-microsoft-excel/</a>).
  I was looking for something native of Excel VBA (first choice), or some insight on the option I mention or another alternative (second choice).</p>
  
  <p>So far, by using code based on Section <em>4. Application Events to Enable All Charts on All Sheets In All Workbooks</em> of <a href="http://peltiertech.com/chart-events-microsoft-excel/" rel="nofollow noreferrer">the link above</a>, I have managed to detect deactivation of any Sheet in any Workbook.
  Then, I can imagine code for point <em>2. With additional Activating/Deactivating to inquire</em>.
  But I do not know about point 1.</p>
  
  <p>(Marginally?) related question: <a href="https://stackoverflow.com/questions/24965291/vba-get-selected-range-in-a-worksheet-where-the-selection-is-a-chart">VBA: Get selected Range in a Worksheet where the Selection is a Chart</a></p>