View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Change Title of Spreadsheet

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