//SOLD, ACTIVE. OFFMARKET
        private void btnDetachedAllCMA_Click(object sender, RibbonControlEventArgs e)
        {
            if (string.IsNullOrEmpty(comboBox1.Text))
            {
                string            caption = "Error Detected in Input";
                MessageBoxButtons buttons = MessageBoxButtons.OK;
                MessageBox.Show("Please Select Subject Property", caption, buttons);
                return;
            }
            ReportCMA cma = new ReportCMA(Globals.ThisAddIn.Application.Worksheets[CMADataSheet], ReportType.CMADetached);

            if (cma.ListingDataValidated)
            {
                try { cma.Residential(ListingStatus.Sold); } catch (Exception ex) { Debug.Write(ex); };
                try { cma.Residential(ListingStatus.Active); } catch (Exception ex) { Debug.Write(ex); };
                try { cma.Residential(ListingStatus.OffMarket, true); } catch (Exception ex) { Debug.Write(ex); };
            }
        }
        private void btnCondoActive_Click(object sender, RibbonControlEventArgs e)
        {
            ReportCMA cma = new ReportCMA(Globals.ThisAddIn.Application.Worksheets[CMADataSheet], ReportType.CMAAttached);

            cma.Residential(ListingStatus.Active);
        }