Hi,
I have name a cell using the same VBA command as follows in 2
different
spreadsheets submitted by 2 different colleagues :


Spreadsheet A
*************
VBA Command Executed : Range("E4").Name = "Overall_CashBegining"

Cell Formula in E5 : "=E4"

Formula Bar Display when cell E5 is selected: "=E4"



Spreadsheet B
***********
VBA Command Executed : Range("E4").Name = "Overall_CashBegining"

Cell Formula in E5 : "=E4"

Formula Bar Display when cell E5 is selected: "=Overall_Cash Begining"


Why is there a different display in the formula bar despite the fact that
other
conditions are the same... only the spreadsheet were submitted by different
people. Is there any options to turn on/off cell naming in formula bar
display ?


Thanks...
--
Regards,
Adrian