Micky
Apparently, Workbook B has code that runs automatically when that file
is opened. What you have to do is either change that code so that it does
you no harm or delete it. Post back if you need more. HTH Otto
"Micky" wrote in message
...
Spreadsheet "A" runs a macro that opens spreadsheet "B". It gets data and
then closes "B" without saving (other spread sheets access "B" and deposit
data). A, then uses data for report.

However, when "B" opens it runs its own macros (the code doesn't ask it to
do this) and this creates a mess.