Need Excel to Start Up on Blank Worksheet

[Hal_MTS]

I have been playing around with VBA at work and at home so have been moving my macros back and forth by copying and pasting them directly in my XLSTART folder. Since I've been doing that though, Excel will no longer start on a blank workbook/worksheet when I open the program from the start menu.

I've tried copying a blank workbook into the XLSTART folder, but then that blank workbook will always open when I start Excel no matter what Excel file I'm opening, which is a pain. If I'm opening WorkData.xls I don't need a blank workbook opening at the same time.

Is there a way to get the settings back so that Excel starts on a blank workbook when I open the program from the start menu but won't open a blank workbook if I open another Excel file?

 

[alansidman]

Put your macros in a personal.xlsb file and locate it in the xlstart folder. Then hide the file. Excel will open with that file hidden and you can then open whatever file you want.

 

[Hal_MTS]

Put your macros in a personal.xlsb file and locate it in the xlstart folder. Then hide the file. Excel will open with that file hidden and you can then open whatever file you want.

Awesome, that worked, thank you so much!