Renaming a sheet

  • Thread starter Thread starter goldcomac
  • Start date Start date
G

goldcomac

When I sometimes rename a sheet it come back .xls]Newname? What's with
the ".xls]" portion? I didn't put that there.

Thanks.
 
It might help us to figure out why if you showed us the code you are using
to rename the sheet.

Rick
 
It's the last 4 characters of the workbook the sheet is in, and that usually
wouldn't appear unless you've linked cell via formula back to another
workbook.
 
It's the last 4 characters of the workbook the sheet is in, and that usually
wouldn't appear unless you've linked cell via formula back to another
workbook.
--
Kevin Backmann



[email protected] said:
When I sometimes rename a sheet it come back .xls]Newname? What's with
the ".xls]" portion? I didn't put that there.
Click to expand...
Thanks.- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

I got it. It showed up because I hadn't renamed the file yet. Once I
did, I could change the names w/o .xls] showing up.
Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with renaming work sheet name 1
Is it possible to load sheet without update links? 2
rename sheets 1
Worksheet renaming 5
Bug? Square brackets in file name confuses sheet renames 10
Edit links 1
SaveAs using VB 2
Different data sheets - same cell, different sheet 2

Back
Top