Macro attaching itself to spreadsheet

  • Thread starter Thread starter J Shrimps, Jr.
  • Start date Start date
J

J Shrimps, Jr.

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?
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro works but also runs original spreadsheet 5
Moving Macros to the Application Level 2
including macro in protected worksheet 2
Log to a file everytime I open a spreadsheet 1
Macro to generate powerpoint slides 43
Macros missing 3
Distribute macro to users 2
Spreadsheet autorun macro, parameter? 3

Back
Top