Excel 2007, Automatically open new worksheet on open.


J

jkmyoung

When I currently open Excel 2007, Excel automatically opens PERSONAL.XLSB.

I want Excel to automatically open a new sheet instead, (like it used to).
Is there any way to do this while still having the macros in PERSONAL.XLSB
available?
I've located the file at ...\AppData\Roaming\Microsoft\Excel\XLSTART, but if
I remove the file the macros are no longer available.

Using windows 7 ultimate.

Side note:
I generally start working on the spreadsheet that opens up, and it doesn't
occur to me to save as a different file since I use quick save shortcuts
(Ctrl-S). I have added macros to PERSONAL.XLSB, and don't want to remove
them. I don't want to have to Close the file and open a new one every time I
start, as I get distracted easily and lose my ideas.
 
Ad

Advertisements

P

Philosophaie

Sub OpenFileInNewWorkbook()
Dim XLApp As Excel.Application
Dim XLBook As Excel.Workbook
Set XLApp = CreateObject("Excel.Application")
XLApp.Visible = True
XLApp.Quit'leave out if you want the workbook still opened
Set XLBook = Nothing
Set XLApp = Nothing
End Sub
 
L

Luke M

Hide your Personal workbook (as in, open the file, and under Windows menu,
hide workbook). Save.

Now when you statup XL, the personal workbook will open-up only in the
background.
 
P

Philosophaie

Change Sub OpenFileInNewWorkbook() to Sub Workbook_Open() and put the whole
file into "ThisWorkbook" in Microsoft Excel Objects foldder
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top