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