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