View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Starting up with Book 1

Lots of people use personal.xls to store macros that they want available
whenever they open excel.

And most people keep that workbook hidden. If you want this:
With personal.xls the activeworkbook, click on Window|Hide
then close excel. You'll be prompted to save personal.xls in that hidden state.

If you really don't want personal.xls and you don't know where it is, you can:

Open excel.
Put this formula in an empty cell in personal.xls:
=cell("Filename",a1)

You'll see the drive/folder/filename/sheet name.

Make a note of it. Close excel and use windows explorer to delete (or just
move???) that file.

===
Or with personal.xls open:
file|properties|general tab
and you'll see the location there.

softnose wrote:

When I start up Excel, it doesn't start up with book 1, but a "personal.xls"
which if i save my changes, will reappear if I start up Excel next time
round.
How do I get Excel to start up with a fresh book 1 every time and get rid of
this "personal.xls"?


--

Dave Peterson