Hi Jimmy,
the first is that when the user begins to enter
the name (which will be the name of the tab) the other
file opens and every letter that is typed the message
saying file is already open. reopening will cause any
changes to be discarded. reopen anywa? or something like
that.
Don't put the code in the EditBox_Change event! Leave it until the
button is clicked.
Regards
Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.co.uk