Macro attaching itself to spreadsheet
 

Have a macro in Book1.xls
Had some spreadsheets open,
and ran the macro on one of them.
Somehow the macro got
attached to another spreadsheet
that happend to be open at the time.

Now evertime I run the macro
the unrelated spreadsheet
opens.
If I delete the spreadsheet,
the macro doesn't run.

How can I prevent this?

Macro attaching itself to spreadsheet
 

Hi

is the name of the "unrelated" workbook Personal.xls? if so, next time it
opens, choose window / hide and this should solve your problem - if it isn't
Personal.xls please paste the code and let us know the name of the
"unrelated" workbook we might be able to figure out what is going on.

Cheers
JulieD


"J Shrimps, Jr." wrote in message
...
Have a macro in Book1.xls
Had some spreadsheets open,
and ran the macro on one of them.
Somehow the macro got
attached to another spreadsheet
that happend to be open at the time.

Now evertime I run the macro
the unrelated spreadsheet
opens.
If I delete the spreadsheet,
the macro doesn't run.

How can I prevent this?

Macro attaching itself to spreadsheet
 

It isn't personal.xls, believe me, that spreadsheet
is well hidden.
I've seen this happen before.
The code is very generic, formating stuff
and placing name of sheet into cell $A$2 and
$B$4 so vlookup function can find associated
data in other spreadsheets.
Have used it for a month with no problems,
now I got problems.
Code is @ work and it's Saturday here
so I can't post it. But I have seen this
happen before with macros in book1.xls
"JulieD" wrote in message
...
Hi

is the name of the "unrelated" workbook Personal.xls? if so, next time it
opens, choose window / hide and this should solve your problem - if it
isn't
Personal.xls please paste the code and let us know the name of the
"unrelated" workbook we might be able to figure out what is going on.

Cheers
JulieD


"J Shrimps, Jr." wrote in message
...
Have a macro in Book1.xls
Had some spreadsheets open,
and ran the macro on one of them.
Somehow the macro got
attached to another spreadsheet
that happend to be open at the time.

Now evertime I run the macro
the unrelated spreadsheet
opens.
If I delete the spreadsheet,
the macro doesn't run.

How can I prevent this?