Excel2000: XLStart-There's gotta be a way....

drew4unc

New Member
Joined
Aug 28, 2002
Messages
2
I'm having trouble getting Excel2K to startup the way I want it to.

1. I put a "personal.xls" hidden workbook in the XLStart folder, with a few macros.
2. This caused Excel to start without opening a blank workbook.
3. To solve this problem, I put a blank workbook "Book1.xls" in the XLStart folder.
4. However, when I open an existing workbook by double-clicking its icon on the desktop, Excel also opens the blank workbook.

Is there any way to avoid the situation described in #4 above?

Thanks for the help.

Drew
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Juan Pablo González

MrExcel MVP
Joined
Feb 8, 2002
Messages
11,959
Did you manually created the workbook ? Excel creates it when you tell him to store the macro in the "Personal.xls workbook". I think it's not a hidden workbook, but a workbook that has its IsAddin property set to True. That probably is what's causing Excel not to open a blank workbook.
 

Juan Pablo González

MrExcel MVP
Joined
Feb 8, 2002
Messages
11,959
Ok, my assupmtion was wrong. It is a hidden workbook. BUT, I created it by recording a macro, and then, restarted Excel, and I got an empty workbook, so, that's problably the thing that you didn't do.
 

Forum statistics

Threads
1,148,274
Messages
5,745,797
Members
423,974
Latest member
highvoltageacdc

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top