Named Range Scope
 

Excel 2007, New, Loan Amortization (Template),
Select cell D5
Unprotect Sheet,
Name Manager,
Loan_Amount, Delete, Ok
New, Name: Loan_Amount, Scope: Loan Amortization Schedule, Ok, Close
It appears that I can change the scope of all names in this workbook
from global to local except
Int_Rate, Loan_Amount, Loan_Start, and Loan_Years. How come?