| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with renaming work sheet name
I came across a file. When I rename the work sheet name, e.g. by typing
"asd", and finish the rename command, the work sheet name automatically appear as ".xls]asd". Why is this ? How to solve it ? Thanks for the help. D Moonn |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Problem with renaming work sheet name
When you say worksheet do you mean workbook? as that is what will have the .xls extension, how are you changing the name, is it via code? if so supply the code and we can help with that. D Moonn;313634 Wrote: I came across a file. When I rename the work sheet name, e.g. by typing "asd", and finish the rename command, the work sheet name automatically appear as ".xls]asd". Why is this ? How to solve it ? Thanks for the help. D Moonn -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=87679 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Problem with renaming work sheet name
Hi Simon,
Thanks for your reply. I do not mean renaming the whole workbook. I rename one sheet in the workbook. I do not know whether or not renaming is via code. I right click a sheet tag, select 'rename' command, type "asd" in the sheet tag, and finally click insdie a cell to finish the rename command. Then the sheet name appears as ".xls]asd". The same ".xls]" appears when I rename another sheet. There is no such problem in other Excel files. It is appreciated for any suggestion. Regeards. D Moonn ----------------------------------------------------------------------------------------- "Simon Lloyd" wrote: When you say worksheet do you mean workbook? as that is what will have the .xls extension, how are you changing the name, is it via code? if so supply the code and we can help with that. D Moonn;313634 Wrote: I came across a file. When I rename the work sheet name, e.g. by typing "asd", and finish the rename command, the work sheet name automatically appear as ".xls]asd". Why is this ? How to solve it ? Thanks for the help. D Moonn -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=87679 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| renaming all work-sheets at once | Excel Discussion (Misc queries) | |||
| vb code for renaming a work sheet with a cell reference | Excel Discussion (Misc queries) | |||
| Problem renaming a worksheet tab | Excel Discussion (Misc queries) | |||
| renaming problem | Excel Worksheet Functions | |||
| problem to work out with excel sheet | Excel Worksheet Functions | |||
Hybrid Mode
