Long ago (10 or more years) I created a mailing list application, using Excel
97 originally, with updates along the way using Excel 2000 and 2003. The
application has been running with Excel 2007 for 18 months without a problem.
Everything has worked smoothly until about two weeks ago.

The user clicks on any of a number of control button on a worksheet to call
a series of routines. In the troublesome routine a list is sorted and
filtered. The filtered list is copied to a new sheet. The sheet is renamed.
The sheet is then moved to a new book. The problem occurs when the move
command executes.

The code is:
With ActiveSheet
.Name = "Publication"
.Move
End With

Prior to the execution of that bit of code every button shows the assigned
macro as "Mail List!macroname" (where "Mail List is hte file name); but when
the ".move" command executes the macros assigned to all of the buttons change
to "Book1!macroname" (where Book1 is the name of the new file).
Additionally, if you open the list of macros, all macros now point to Book1
and not to the original file name.

Until now, the application has worked like a charm, with the last major
update in 2004.

What can I do to keep this file name switch from happening?