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!!

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!!

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!!

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

I can't believe I didn't think of that. Thank you for the info. Found it and
deleted it!

"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

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

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

You can delete it but the next time you create a macro you may just re-create
Personal.xls.

It is handy to have one where you store all global macros.

Just save as a hiden file and you won't even know it is there.


Gord Dibben MS Excel MVP

On Wed, 19 Dec 2007 09:52:01 -0800, 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!!

Personal.xls always opens if you have macros created. However, it is usually
saved as a hidden file.

The next time you open Excel and personal.xls opens, Click Window Hide.
When you close Excel it will prompt you to save the personal.xls file. Click
Yes and it will open as hidden and you will not see it. You need it to open
if you want to use any global macros you have created.

"Stockwell43" wrote:

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!!