Copying Worksheet Problem

H

Heather

Hello

I have a file that I can normally copy the left hand sheet
to create a new sheet for a new month's information.

It does not allow me to copy that far left hand sheet
(let's say April), but it will allow me to copy any of the
other sheets (let's say March)

After manually creating a new sheet from March and
renaming it May and saving the file, then I tried to copy
a new sheet from April and it wouldn't let me, then I
tried May and it wouldn't let me.... then I tried March
again and it did.

WEIRD !!!! Please help... thanks
 
H

Heather

I have figured out that in Visual Basic's properties of
the sheet that the sheet name was 421111111111111 and it
didn't have enough characters to create another sheet...
for some reason in prior months each time a sheet was
created it was adding another 1 on the end of the sheet
name... (even though I can see the sheet name as March04)

If someone could help with why this occurred that would be
excellent...

Thanks
 
B

beeawwb

As to why it occurred...

As far as I know, when you go

Right Click sheet Tab->Move Or Copy->Create a Copy

Excel tacks a 1 on the end of the existing sheet name (VBA sheet name
not Viewed Sheet name), to associate it with the previous 'copy
original'.

So, where you see "March 04", I *think* that would b
Sheet42.Label="March 04" or something like that.

I don't know what can be done about it though.

Hope it helps,

-Bo
 
R

Ron de Bruin

This is a bug in Excel 97 as far as I know
The only way is to edit the Sheet code name

Press F4 with a sheet name selected in the VBA editor
You can change it in the properties
 
Top