Excel file automatically opens

Once I've open my Trouble.xls file, the file automatically opens whenever I open any other file. This occurs if I close the Trouble.xls file and open another file without exiting EXCEL - 97 and 2000 versions. If I begin EXCEL with any other file everything runs fine until I open the Trouble.xls file. From then on the Trouble.xls file will not go away until I exit EXCEL.

If I close the Trouble.xls file while any other file is also open, the Trouble.xls file closes, however, opens right up again.

The Trouble.xls file is not listed in the EXCEL/Startup thing-a-ma-jig. I've searched the File/Properties thing-a-ma-jig and see nothing out of line.

Any thoughts where to look?

Thanks from Lost4Now

Do you run any macros that are in Trouble.xls? Even if you meant to change the
assigned macro to a different workbook, maybe you missed one.

I'd look through any buttons/toolbars that you've created.

But that doesn't explain why the trouble.xls opens when you open another
workbook.

There is a possibility that you have set up a reference to trouble.xls in the
workbook that gets opened.

Open one of those workbooks that also opens trouble.xls.
(Verify that trouble.xls is open)

Hit alt-F8 to get to the VBE
hit ctrl-r to see the project explorer
select the workbook (not trouble.xls) that you opened
Click on tools|references

Do you see a checkmark that points back to trouble.xls's project?

If you do, then you can uncheck that and then save that workbook. That'll fix
it for one workbook--not all of them.

If this was the problem, then the next thing I'd look at is your book.xlt
template file in your XLStart folder.

If you use this, then maybe that book.xlt has a reference to trouble.xls. And
every workbook that was based on that book.xlt template will inherit this
reference.

Remove the reference and save book.xlt.

One more place to check...

You could have a macro (auto_open or workbook_open) that opens this trouble.xls
file. You've checked for this?



Lost4Now wrote:
>
> Once I've open my Trouble.xls file, the file automatically opens
> whenever I open any other file. This occurs if I close the Trouble.xls
> file and open another file without exiting EXCEL - 97 and 2000 versions.
> If I begin EXCEL with any other file everything runs fine until I open
> the Trouble.xls file. From then on the Trouble.xls file will not go
> away until I exit EXCEL.
>
> If I close the Trouble.xls file while any other file is also open, the
> Trouble.xls file closes, however, opens right up again.
>
> The Trouble.xls file is not listed in the EXCEL/Startup thing-a-ma-jig.
> I've searched the File/Properties thing-a-ma-jig and see nothing out of
> line.
>
> Any thoughts where to look?
>
> Thanks from Lost4Now
>
> --
> Lost4Now
> ------------------------------------------------------------------------
> Lost4Now's Profile: http://www.excelforum.com/member.php...o&userid=29345
> View this thread: http://www.excelforum.com/showthread...hreadid=490562

--

Dave Peterson

Thanks Dave:

Struck out!

No reference to the Trouble.xls file in the VBE Editor.

Yes, there are numorous macros in the Trouble.xls spreadsheet, but the auto_open and workbook_open macros are clean.

I'm not familiar with the book.xlt file. Couldn't locate one with Windows Explorer. Found some excel .xlt files in the Template/Spreadsheet Solutions folder - but are not linked to any of my files.

Doesn't matter if the other .xls files have macros or not. When they are opened, Trouble.xls opens and of course will not close out until I close out all other files that I have open.

Noticed one thing! One of the my files opens with the "Macro Caution - Enable or Disable" thing-a-ma-jig. The file doesn't contain any macros???? This is a new file that was created long after I began having problems.

Any virus or hidden macros known to cause excel to act this way? I'm using '97 and 2000!

Thanks - Dean Thomas

You'll want to check the auto_open/workbook_open procedures in the other
workbooks. They may be opening trouble.xls.

Look for XLStart (using windows explorer). Maybe that'll help you find any
book.xlt files that you missed.

If you open a workbook and get that "this workbook contains macros", then excel
still thinks that it does.

Debra Dalgleish has some instructions:
http://www.contextures.com/xlfaqMac.html#NoMacros
to help clean it up.

=======
I was thinking that if you had buttons (on a toolbar or on a worksheet) that had
macros assigned to them that the assigned macros could still be pointing to
problem.xls.

But you'd have to run that macro (click the button) to open problem.xls.

I don't have any other guesses...

Maybe someone else has some.



Lost4Now wrote:
>
> Thanks Dave:
>
> Struck out!
>
> No reference to the Trouble.xls file in the VBE Editor.
>
> Yes, there are numorous macros in the Trouble.xls spreadsheet, but the
> auto_open and workbook_open macros are clean.
>
> I'm not familiar with the book.xlt file. Couldn't locate one with
> Windows Explorer. Found some excel .xlt files in the
> Template/Spreadsheet Solutions folder - but are not linked to any of
> my files.
>
> Doesn't matter if the other .xls files have macros or not. When they
> are opened, Trouble.xls opens and of course will not close out until I
> close out all other files that I have open.
>
> Noticed one thing! One of the my files opens with the "Macro Caution -
> Enable or Disable" thing-a-ma-jig. The file doesn't contain any
> macros???? This is a new file that was created long after I began
> having problems.
>
> Any virus or hidden macros known to cause excel to act this way? I'm
> using '97 and 2000!
>
> Thanks - Dean Thomas
>
> --
> Lost4Now
> ------------------------------------------------------------------------
> Lost4Now's Profile: http://www.excelforum.com/member.php...o&userid=29345
> View this thread: http://www.excelforum.com/showthread...hreadid=490562

--

Dave Peterson

This message can occur if any empty module(s) left over after deleting any
macros that were created.

With that workbook open, go to VBE and look for any "module" in the project.

Right-click and "remove".

Click "no" to do you want to export.

For more on this see Debra Dalgleish's site.

http://www.contextures.on.ca/xlfaqMac.html#NoMacros

This info, of course, does not resolve the original problem with Trouble.xls


Gord Dibben Excel MVP

On Sun, 4 Dec 2005 12:43:31 -0600, Lost4Now
<[email protected]> wrote:

>Noticed one thing! One of the my files opens with the "Macro Caution -
>Enable or Disable" thing-a-ma-jig. The file doesn't contain any
>macros???? This is a new file that was created long after I began
>having problems.
>
>Any virus or hidden macros known to cause excel to act this way? I'm
>using '97 and 2000!

Thanks for sharing the "Remove the empty module". I'd forgotten that they needed to be removed.

The Troubles.xls doesn't have any additional menu items or alterations to the standard menus and menu items. The buttons and hyperlinked cells all refer to range names in the workbook.

When I open several workbooks with no macros in them, then open the Troubles.xls, I'm in the loop of not being able to close the Troubles.xls without closing all other open workbooks. After closing Troubles.xls then opening up any other file - macros or not - Troubles.xls reloads.

My quess is that Troubles.xls must have something in the macros that tells excel that whenever a file is loaded that Troubles.xls is also to be loaded. I've reread all the coding over and over and see absolutely nothing of that nature. I'm reluctant to attach the file, because the file is my finanacial tracker and wouldn't want anyone else to possibly end up with whatever it is that is that I've done or got hold of. To reiterate, If I exit EXCEL, the Troubles.xls doesn't load when I open the other files. Begins to happen after I open Troubles.xls

I have nothing in XLStart folder.

Thanks for your time and assistance.

Dean Thomas

Next time this happens, go into the VBE and hit ctrl-r to see the project
explorer.

What workbook/projects do you see open?

====
Also, you can try this:

close excel and reopen it in safe mode.

Windows start button|run
type this and hit enter:
excel /safe

Now test it out a bit.

By starting excel in safe mode, you're disabling macros. If the problem doesn't
come back, I'd look close excel and reopen normally and continue looking for
code--in any of the workbooks that are open.

For instance, I have a routine in my personal.xla that sets an ontime procedure
each time that the workbook closes. If excel is still running, my personal.xla
gets reloaded. If excel is not running (when I quit excel), then it doesn't do
anything.



Lost4Now wrote:
>
> Thanks for sharing the "Remove the empty module". I'd forgotten that
> they needed to be removed.
>
> The Troubles.xls doesn't have any additional menu items or alterations
> to the standard menus and menu items. The buttons and hyperlinked
> cells all refer to range names in the workbook.
>
> When I open several workbooks with no macros in them, then open the
> Troubles.xls, I'm in the loop of not being able to close the
> Troubles.xls without closing all other open workbooks. After closing
> Troubles.xls then opening up any other file - macros or not -
> Troubles.xls reloads.
>
> My quess is that Troubles.xls must have something in the macros that
> tells excel that whenever a file is loaded that Troubles.xls is also to
> be loaded. I've reread all the coding over and over and see absolutely
> nothing of that nature. I'm reluctant to attach the file, because the
> file is my finanacial tracker and wouldn't want anyone else to possibly
> end up with whatever it is that is that I've done or got hold of. To
> reiterate, If I exit EXCEL, the Troubles.xls doesn't load when I open
> the other files. Begins to happen after I open Troubles.xls
>
> I have nothing in XLStart folder.
>
> Thanks for your time and assistance.
>
> Dean Thomas
>
> --
> Lost4Now
> ------------------------------------------------------------------------
> Lost4Now's Profile: http://www.excelforum.com/member.php...o&userid=29345
> View this thread: http://www.excelforum.com/showthread...hreadid=490562

--

Dave Peterson