Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't rename worksheet
Excel 2003, when trying to rename a worksheet, I get the following message:
"Cannot rename a sheet to the same name as another sheet, a referenced object library or a workbook referenced by Visual Basic" I created the file and I don't use VB, don't know what a referenced object library is, and there are no other sheets with the same name. There was a worksheet with the same name which was mistakenly deleted--I can't find it anywhere, and there is no protection on any worksheets in the file. ?? Thanks for idea. I want to use the same name as the deleted sheet: I've copied the deleted sheet from a backup file but can't use the old name. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't rename worksheet
I bet you didn't delete it. Maybe you just hid it.
You could try: Format|Sheet|Unhide. The sheet could be "very hidden". So it won't show up in this dialog. You could try this next: Hit alt-F11 (to get to the VBE) hit ctrl-r (to see the project explorer) select your workbook's project Hit the asterisk on the number keypad. You should see a list of all the objects that belong to this project--including all the worksheets. If you see one that has the name you're trying to use in parentheses, like: Sheet1(YourSheetNameHere) Then click on it and hit F4 to see its properties. Look for visible on the left hand side in that window Click on the right hand side of that option. choose: -1 - xlsheetvisible using the dropdown arrow Then back to excel to see if you can actually see that worksheet. Then you can delete it or rename it or just use it. Brian Preston wrote: Excel 2003, when trying to rename a worksheet, I get the following message: "Cannot rename a sheet to the same name as another sheet, a referenced object library or a workbook referenced by Visual Basic" I created the file and I don't use VB, don't know what a referenced object library is, and there are no other sheets with the same name. There was a worksheet with the same name which was mistakenly deleted--I can't find it anywhere, and there is no protection on any worksheets in the file. ?? Thanks for idea. I want to use the same name as the deleted sheet: I've copied the deleted sheet from a backup file but can't use the old name. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rename the worksheet | Excel Discussion (Misc queries) | |||
how do i rename worksheet to equal cell name | Excel Worksheet Functions | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions |