Unable to copy/move worksheet to the end of a workbook

[Karebear]

I have a user that is unable to do the move/copy feature in Excel, she created 11 tabs and is trying to create a new sheet at the end and it just won't create it. No error message just won't do it. Any ideas?
Karebear...

 

[VBAjedi]

It's been a while since I messed with this one, but as I recall there is a possibility that, if the user pastes a sheet in, then copies that sheet, then pastes the new copy in, and copies that new sheet, they will run into problems with the sheet's "code name" (the name Excel uses behind the scenes to refer to the sheet). The reason for this is that if you copy "Sheet1" Excel gives it the code name "Sheet11". Copy that new sheet and Excel calls the copy "Sheet111". Soon you run out of digits (Excel doesn't like long code names).

To check for this problem, right click a sheet name and select "View Code". Then look in the upper-left panel (the Project panel) at the sheet objects. The visible name of each sheet will be followed by the code name in parentheses.

If the code names are as I've described you can rename them in the Properties panel (which may or may not be visible already - click on the View menu if not).

Hope that helps! It may be something else entirely, but this is an easy thing to check. . .

VBAjedi

 

[Karebear]

I missed that one by a mile, thanks that is the one thing I didn't check and that did the trick.
Thanks for your help,
Karebear

 

[VBAjedi]

It's been a while since I messed with this one, but as I recall there is a possibility that, if the user pastes a sheet in, then copies that sheet, then pastes the new copy in, and copies that new sheet, they will run into problems with the sheet's "code name" (the name Excel uses behind the scenes to refer to the sheet). The reason for this is that if you copy "Sheet1" Excel gives it the code name "Sheet11". Copy that new sheet and Excel calls the copy "Sheet111". Soon you run out of digits (Excel doesn't like long code names).

To check for this problem, right click a sheet name and select "View Code". Then look in the upper-left panel (the Project panel) at the sheet objects. The visible name of each sheet will be followed by the code name in parentheses.

If the code names are as I've described you can rename them in the Properties panel (which may or may not be visible already - click on the View menu if not).

Hope that helps! It may be something else entirely, but this is an easy thing to check. . .

VBAjedi