Yes, renaming the cell is what I want to do but for some reason it would let
me. I went into Tools and it doesn't look like the sheet is protected, I
looked to see if any Macros were assigned and none of that is happening. It
is a worksheet created by someone else that I am trying to modify. I think
maybe I just need to re-create it myself so I can make necessary changes when
needed because there are several cells like this and I don't know how to
change any of them. Please let me know if I am overlokking anything.

Thanks!!!

"Dave Peterson" wrote:

I don't understand what you mean by renaming the cell?

If you mean you want to enter a different value, then that new value will have
to adhere to the data|validation rules.

If you really meant you wanted to rename the cell (Insert|Name|Define), then
make sure that the worksheet is not protected (just a guess).

Stockwell43 wrote:

I can empty the field by hitting the delete key however, it won't let me
re-name the field to something else.

"Dave Peterson" wrote:

It sounds like the developer put some Data|Validation (in xl2003 menu system)
rules in that cell.

If I enter something incorrectly in one of those cells, I usually just hit
ESCape to put it back to what it was before.

You could also hit the delete key (after you dismiss that warning dialog) to
clear the contents of the cell.

Stockwell43 wrote:

Ok, one more question.

When I try to make a change in a certain cell, it gives me a warning not to
make changes and won't let me do it. I can hit cancel to get out but it will
not even let me move to another cell unless I hit cancel. Where do I find the
formula or controls for this? I didn't see a macro attached. Sorry, I am not
much on Excel as I work mostly with Access so forgive me if I seem a bit
dense on how to do certain things.

Thanks!!!

"Dave Peterson" wrote:

Close excel
Use windows start button|Search
and look for personal.xls

Delete the ones you know you don't want.

Stockwell43 wrote:

Is there a way to just delete this worksheet altogether? I delete the Macro
but for some reason the sheet is still there?

"Don Guillett" wrote:

Personal.xls was created when you recorded a macro to it. You may delete or
better yet put this macro in it to toggle hiding/unhiding. I have it
assigned to a button on my MENU.xls that opens when I open excel.


Sub TogglePersonal()
Windows("PERSONAL.XLS").Visible = Not Windows("PERSONAL.XLS").Visible
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Stockwell43" wrote in message
...
Hello,

I have a weird kind of question. Every time I open Excel, the first
worksheet comes up as Personal.xls but when I click on the icon to open a
new
worksheet, it opens as book1.xls. Why it is opening with personal.xls and
how
do I get rid of it? I remember doing something with a macro from a
prcatice
excerise but I delted the macro. Any help would be appreciated.

Thanks!!



--

Dave Peterson


--

Dave Peterson


--

Dave Peterson