You make that spreadsheet a template and save it to your StartUpPath and name
the workbook Book.

You can find your startuppath by entering the following from the immediate
window of VBE (alt-f11) and if your immediate window is not visible ctrl-g

? Application.StartupPath

Then assuming you have previously saved this workbook as a template, you can
copy the path that is returned and type the following (I'll use my
startuppath for illustration purposes.) My startup path is :
C:\Documents and Settings\kevinv\Application Data\Microsoft\Excel\XLSTART

With your workbook as the active workbook type:

ThisWorkbook.SaveAs "C:\Documents and Settings\kevinv\Application
Data\Microsoft\Excel\XLSTART\book"

notice as I had previously saved it as a template, I did not need to include
the extension (.xlt iirc)

I'm sure there are other ways of doing this, but I am under a, probably
unique situation, where I have to do it this way (I can't navigate to my
startup directory using explorer as I'm using Citrix (which brings up another
copy of the Windows OS) that someone else has set up and when I try, it just
can't be found.)

--
Kevin Vaughn


"TmaccTbay" wrote:

Hi,

Can you make a workbook spreadsheet your default so that everytime you open
excel it comes up different that the default is now?