After reading your explanation, I don't think that the timing issue is the
problem.

But good luck finding, er, solving the problem.

sknowles wrote:

Dave -
Thanks for the pointers - I will try both the newsgroup, and the timing
trick.

To try to clarify my confusing statement: the compile error occurs when
I open the workbook, after I click the "Enable Macros" warning, but
before any of the routines in my Workbook_Open() are executed. But I do
not actually call the MA_Repair_Links sub from that event, anyway -
it's executed only when the user selects an action from the menu, after
the workbook is open.

Thanks again for the tips; I'll let you know how it works out.
- Steve

--

Dave Peterson