Excel Property Name Corrupted

[jfllmartin]

I have an Excel 2003 spreadsheet with a macro that makes a copy of the last sheet and does some minor updating of the data to prepare for the next day's entries. I change the sheet tab name to the calendar date. I have this in a number of our remote locations working fine. There is one location where the file seems to have a bug in it. The internal sheet name (VBA Properties) does not increment normally. So instead of Sheet66 as the sheet name, I get Sheet661, then Sheet6611, Sheet66111, and so one until the name is too long and brings up an error message. I cannot seem to find any else who has this problem Thanks

 

[Andrew Poulsom]

What version of Excel are they using? That behaviour is normal in Excel 97, as documented here:

http://support.microsoft.com/kb/177634

 

[jfllmartin]

Thanks for your reply Andrew. My original post notes I am using Excel 2003. My code is not looping. The user clicks a button (usually only once a day) that does the following:

Sheets(Sheets.Count).Activate
With ActiveSheet
.Unprotect
.Select
.Copy After:=Sheets(Sheets.Count)
.Protect
End With
...more code

 

[Andrew Poulsom]

It's which version the problem user has that matters.

 

[jfllmartin]

Andrew,

I finally found out they are using Excel 97, so your reference to Microsoft is exactly right. Somehow I need to get them on to a newer version. Thank you for your time and effort with this.