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