View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brian Preston Brian Preston is offline
external usenet poster
 
Posts: 1
Default 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.