How do I get only one worksheet to open?

ouonomos · Mar 1st, 2002, 12:07 PM

I began saving macros in various workbooks that I was creating. I thought I saved them all to the "Personal" workbook. Now when I open excel, all the workbooks in which I ever saved a macro open. This happens now even though I deleted all the macros. How to I make excel open only a new worksheet when I first open it, and none of these other workbooks? Thx for any help.

Mark W. · Mar 1st, 2002, 12:41 PM

Is there an entry in the "Alternate startup file location" field on the Tools | Options... | General tab?

Ziggy · Mar 1st, 2002, 08:50 PM

are the files located in XLstart folder that will cause them to start up when Excel is started.

ouonomos · Mar 7th, 2002, 02:08 PM

There do not seem to be any entries in the "the Alternate startup file location" field on the Tools | Options... | General tab. How do I find the "XLstart folder that will cause them to start up when Excel is started"? Thxs for your replies.

Ziggy · Mar 7th, 2002, 07:55 PM

Just do file search on c: drive for XLstart.

Also I think sometimes even though you remove the code from a module in a macro recorded in "THis Work book" you need to remove the module the code was in(even if it's empty)

ouonomos · Mar 7th, 2002, 10:51 PM

Ok thx very much. I'll try it.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 1st, 2002, 12:07 PM	#1
ouonomos New Member Join Date: Feb 2002 Posts: 3	I began saving macros in various workbooks that I was creating. I thought I saved them all to the "Personal" workbook. Now when I open excel, all the workbooks in which I ever saved a macro open. This happens now even though I deleted all the macros. How to I make excel open only a new worksheet when I first open it, and none of these other workbooks? Thx for any help.

Mar 1st, 2002, 12:41 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Is there an entry in the "Alternate startup file location" field on the Tools \| Options... \| General tab?

Mar 1st, 2002, 08:50 PM	#3
Ziggy Board Regular Join Date: Feb 2002 Location: Ontario, Canada Posts: 326	are the files located in XLstart folder that will cause them to start up when Excel is started.

Mar 7th, 2002, 02:08 PM	#4
ouonomos New Member Join Date: Feb 2002 Posts: 3	There do not seem to be any entries in the "the Alternate startup file location" field on the Tools \| Options... \| General tab. How do I find the "XLstart folder that will cause them to start up when Excel is started"? Thxs for your replies.

Mar 7th, 2002, 07:55 PM	#5
Ziggy Board Regular Join Date: Feb 2002 Location: Ontario, Canada Posts: 326	Just do file search on c: drive for XLstart. Also I think sometimes even though you remove the code from a module in a macro recorded in "THis Work book" you need to remove the module the code was in(even if it's empty)

Mar 7th, 2002, 10:51 PM	#6
ouonomos New Member Join Date: Feb 2002 Posts: 3	Ok thx very much. I'll try it.