Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007, Automatically open new worksheet on open.
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007, Automatically open new worksheet on open.
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 "jkmyoung" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007, Automatically open new worksheet on open.
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. -- Best Regards, Luke M "jkmyoung" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007, Automatically open new worksheet on open.
Change Sub OpenFileInNewWorkbook() to Sub Workbook_Open() and put the whole
file into "ThisWorkbook" in Microsoft Excel Objects foldder "Philosophaie" wrote: 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 "jkmyoung" wrote: 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007, Automatically open new worksheet on open.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you make a userform open automatically when you open excel? | Excel Worksheet Functions | |||
automatically open a specific worksheet when starting excel 2007 | Excel Discussion (Misc queries) | |||
How do I open a workbook automatically in Excel 2007/Vista | Excel Discussion (Misc queries) | |||
Excel 2007 automatically redirects to an incorrect open source fil | Links and Linking in Excel | |||
When I open Excel, workbooks open automatically. How can I stop t | Excel Discussion (Misc queries) |