ExcelBanter - Scope of name

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Scope of name (https://www.excelbanter.com/excel-discussion-misc-queries/250920-scope-name.html)

Slim Slender

Scope of name

I have been unable to change the scope of some names from global (workbook)
to local (worksheet) in the Loan Amortization template in Excel 2007. There
are 29 names in the workbook. I was able to change 25 of them but I could not
delete and then recreate the Int_Rate, Loan_Amount, Loan_Start, and
Loan_Years as worksheet scope names. Does anyone know why?

All times are GMT +1. The time now is 11:55 PM.