VSTO - Named Range Control Basic Operation

Add Named Range

 Microsoft.Office.Tools.Excel.NamedRange AuthorNamedRange = null;
 Excel.Range AuthorRange = this.Range["E1", "G1"];
 // Setting the range name for cells
  AuthorNamedRange = this.Controls.AddNamedRange(AuthorRange, "AuthorCells");

Add Change Event to  Named Range

AuthorNamedRange.Change += new Excel.DocEvents_ChangeEventHandler(AuthorNamedRange_Change);

void AuthorNamedRange_Change(Excel.Range Target)
        {
            MessageBox.Show("123");
        }

Loop through Named Range in one sheet

            foreach (Microsoft.Office.Tools.Excel.NamedRange n in this.Controls.OfType<Microsoft.Office.Tools.Excel.NamedRange>())
            {
                string s = n.RefersToRange.AddressLocal;
            }

Add Border Around

preFilledRange.BorderAround(missing, Excel.XlBorderWeight.xlThin,
Excel.XlColorIndex.xlColorIndexAutomatic, missing);

Protected (only cell "A1" can be edited)

 Microsoft.Office.Tools.Excel.NamedRange namedRange2 =Controls.AddNamedRange(this.Range["A1", missing],"namedRange2");
            namedRange2.Locked = false;
            this.Protect("123");