ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   HELP!! It's STuck (https://www.excelbanter.com/excel-discussion-misc-queries/94489-help-its-stuck.html)

ConfusedNHouston

HELP!! It's STuck
 
I've been using Excel for about 14 years. Have never seen this before. I
opened a new worksheet and instead of it being called Sheet 4, it had some
strange name like copy_[2]_list. I deleted that name (without taking note of
it and renamed the worksheet My List. Well now I'm in a loop.

I get the following error statement "You entered an invalid name (for the
sheet) make sure the name doesn't exceed 36 characters..." You know the
message I'm talking about. I've tried everything that I know to do. I've
named the worksheet "1". I've named it "page". I've deleted, cut, and have
done everything I know to the name of that sheet and the error msg won't go
away.

I've got about 4 weeks worth of data on the other 3 sheets in the file but I
can't get to it because I'm in this endless argument with Excel over the name
of this empty worksheet. Yes I have some back-ups but they're missing about
2 hours of my most recent work.

I can't leave the sheet. I can't save the file. I can't do squat without
the rules for sheet-naming popping up. Any ideas regarding a data-save at a
minimum? Oh, and obviously I need all ideas relating to "escaping" this
error message trap.

Thanks.

mrice

HELP!! It's STuck
 

Have you tried setting the name with VBA?

In the editor window ( ALT F11) , hit control G to open the immediate
pane and type in

ActiveSheet.Name = "MySheet"


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=552820



All times are GMT +1. The time now is 11:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com