Appreciate any help / advice.

We have a worksheet created in Excel (Office 97) that is
used for a type of stock control. Each sheet refers to a
week and at the end of the week, a sheet is created by
copying the last sheet.

We've found that this now causes Excel to crash when we
try to save. I've looked in the "Visual Basic Editor"
(under "Tools", "Macro") and found that the sheets are
being given a name such as Sheet2111(week4) and then each
new sheet the number increases by an additional digit (eg.
the next sheets would be Sheet21111(week5) and Sheet211111
(week6). (Currently up to Week28!)

Is it possible to modify these names in the VBA editor to
stop the crashing?

Many thanks in advance for any assistance