Macros forcing file open

G

Guest

I have several old macros set up in Excel; they are stored in the
personal.xls sheet. I was working on a small file the other day (filename =
friday.xls). I must have done something unusual when I saved the file. Now
whenever I execute any macro, I get the following error message: "friday.xls
contains macros". Excel asks me to Disable or Enable the macros, and then it
opens up friday.xls. Any ideas on why Excel opens this file? Any idea on how
to correct it? Thanks in advance!
 
D

Dave Peterson

How are you executing that macro (some sort of button on a worksheet?).

It sounds like the button has a macro assigned to it that points at that
friday.xls file.
 
G

Guest

I have 4 macros with each being assigned a unique button in the toolbar.
Regardless of which macro is invoked, Excel opens the Friday.xls file.
 

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

Top