Macros forcing file open
 

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!

Macros forcing file open
 

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.

brodine wrote:

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!

--

Dave Peterson

Macros forcing file open
 

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.

"Dave Peterson" wrote:

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.

brodine wrote:

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!

--

Dave Peterson