How do I stop Excel from opening all files w/macros & running them

B

BobC

Hello,
Whenever I open Excel (just the program), it launches into opening all my
excel files that have macros in them. Something is auto-starting when I open
Excel and I cant find it. I dont have any "open files in target" in my icon,
and when I open up and edit macros all are cleared out, including nothing
under VBA for PERSONAL.XLS. It's driving me nuts. Where else can I look to
turn this off? Thanks!
 
G

Gary''s Student

Do the following:

Tools > Options... > General > and clear out "At startup, open all file in:"

Clear any junk out of your XLSTART folder
 
B

BobC

Thanks - there is nothing there in the options tab in that field, and XLSTART
is already empty! Any other ideas? thanks.
 
S

Sheeloo

What happens if you double click any Excel file to open?
Does it open ALL the workbooks with macros or only the recent ones?
What do you mean by 'all are cleared out'... if there are no macros then why
do you say all files with macros open up... If you are not doing this then
press ALT-F11 to open VB Editor and see what you get...

Try out this...
Either disable macros or press SHIFT while clicking on Excel shortcut... do
you still have the problem?...

Locate and open Excel directly by running Excel.exe (and not from a short
cut)...

Also in such situations deleting the normal.dot for Microsoft WORD is said
to do the trick... no idea why it works or why the problem occurs.
 
B

BobC

Sheeloo,
Ok -
Same thing happens if you open from shortcut, from excel.exe in Office pgm
folder, or double-clicking any excel file - whether it had macros or not.

Opens all files that ever had a macro only.

I have deleted all the macos from VBE editor - nothing left in there when
you go to VBE.

Holding SHIFT when opening excel has no effect - still opens the files.

I cant find NORMAL.DOT - where is that file?

I think something must be up with PERSONAL.XLS but that shows empty within
VBE editor too.

Thanks! Any more thoughts?
 

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