View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Change Title of Spreadsheet

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