Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11
Default How do I stop Excel from opening all files w/macros & running them

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!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default How do I stop Excel from opening all files w/macros & running them

Do the following:

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

Clear any junk out of your XLSTART folder
--
Gary''s Student - gsnu200843


"BobC" wrote:

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!

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11
Default How do I stop Excel from opening all files w/macros & running

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

"Gary''s Student" wrote:

Do the following:

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

Clear any junk out of your XLSTART folder
--
Gary''s Student - gsnu200843


"BobC" wrote:

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!

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 248
Default How do I stop Excel from opening all files w/macros & running

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.

"BobC" wrote:

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

"Gary''s Student" wrote:

Do the following:

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

Clear any junk out of your XLSTART folder
--
Gary''s Student - gsnu200843


"BobC" wrote:

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!

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11
Default How do I stop Excel from opening all files w/macros & running

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?


"Sheeloo" wrote:

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.

"BobC" wrote:

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

"Gary''s Student" wrote:

Do the following:

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

Clear any junk out of your XLSTART folder
--
Gary''s Student - gsnu200843


"BobC" wrote:

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!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto run of macros immediately after opening the files gane Excel Worksheet Functions 2 October 31st 07 02:41 PM
How to Stop Explorer from Opening Online Excel Files Angola Rick Excel Discussion (Misc queries) 2 September 26th 06 02:18 AM
How do I stop Book 1 opening with existing files? sirbob Excel Discussion (Misc queries) 2 April 3rd 06 10:18 AM
Running Virus Scan Slowing down opening files Angelina Excel Discussion (Misc queries) 2 August 15th 05 12:41 AM
How do I stop Macros from opening with every excel spreadsheet? AlexMilos Excel Discussion (Misc queries) 1 January 13th 05 08:44 PM


All times are GMT +1. The time now is 12:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"