Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel macros occasionally do not run
I have a rather complex Excel vba application. It has about 10 sheets
each with 10 to 20 code modules. When the spreadsheet is opened, it runs the Worksheet_Open event, which calls all of the subs as needed. The entire app takes about 5 minutes to run. Occasionally I open the spreadsheet and it goes straight to the sheets without running my macros. It always asks to enable/disable the macros, this happens after they are enabled. I have a refresh button on one of my sheets. I can click this button and the macros run as expected. This is how I know that macros have been enabled. Any ideas as to why this occurs. thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup occasionally returns formula with no data | Excel Discussion (Misc queries) | |||
Lookup function gives wrong values occasionally | Excel Discussion (Misc queries) | |||
Excel Calculations Open in Manual Occasionally | Excel Discussion (Misc queries) | |||
Macro that stops at a mid point occasionally | Excel Programming | |||
Occasionally losing the scroll bar function...weird | Excel Programming |