Named Range Scope

S

Slim Slender

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scope of name 0
Name Scope 2
Range Name Scope 4
How can I change a Name scope from local to Global? 7
Deleting all named ranges that have a workbook scope 3
How can I change a Name scope from local to Global? 0
Named ranges dissapear from list 4
Scope of range names 4

Top