| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open file with macros | Excel Discussion (Misc queries) | |||
| Open file without macros | Excel Programming | |||
| Forcing MS Query to run before macros | Excel Programming | |||
| Forcing users to enable macros | Excel Programming | |||
| Forcing Macros to Run (Else Deny Access to Workbook) | Excel Programming | |||
Linear Mode
