View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Slim Slender Slim Slender is offline
external usenet poster
 
Posts: 4
Default 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?