can't rename a sheet

[Dan]

Hi,

I got the following error when I tried to rename a sheet (chart) back to it’
s original name:
“Cannot rename a sheet to the same name as another sheet, a referenced
object library or a workbook referenced by Visual Basic”

Here’s what happened:
I initially created a sheet named “mychart”
I made another sheet “mychart(2)” by copying “mychart”, and deleted
“mychart”.

I found out “mychart” was still referenced in VBAProject as
“chart4(mychart)”, even the sheet was deleted. And I couldn’t delete
“chart4(mychart)” in VBA Project Explorer.

Any way to fix it? Thanks a lot.

 

[Dave Peterson]

I'm not sure I've ever seen this.

Any chance that the chart sheet exists, but is hidden?

Inside the VBE, hit ctrl-R to see the project explorer
hit F4 (to see the properties window)
click on that chart sheet.

Look for Visible (near the bottom when you're on the Alphabetic list).

If it's not visible, use the dropdown to change it to visible.

If it is visible and you can't see it, then it sounds like it's not really
there--what you said first!

Maybe you could rename it to some unique name that you'll never ever use.

Just type of the (Name) property and the Name property.

The (Name) property is the codename. The Name property is the one the user
sees(!) on the sheet tab.

But this can't be a good thing. If it doesn't go away, I'd be recreating this
workbook. I'd be afraid that if something went wrong, then I might lose it
completely (mostly paranoia, but ....).

 

[Dan]

Dave,

Thanks so much for the help. "hidden" was the problem. I don't know how it
happened, cause I clearly remember I deleted it.

Thanks again,

Dan