Complie Excel Code Here End

Im developing a set of macros (on WinXP) and testing them on iMacs.

Even more interesting (to me), I can later run the routine that calls this module (after quitting the IDE and manually setting my global variables), and it works fine Im doing most of my testing on Microsoft Excel X for MacAE Service Release 1 (2001), but am getting the same behaviors on other Mac versions.

But if you do call it in the workbookopen event, Ive seen posts that describe timing issues (for a lack of a better term) that can occur.

Complie Excel Code Here End

Some people suggested something like: Private Sub WorkbookOpen() Application.OnTime Now, ContinueOpen End Sub Then in a general module: sub ContinueOpen() your real code here end sub (But I have no real idea--wintel only here.) sknowles wrote: Hopefully, someone has seen this knows a work-around - its making me crazy.

Thanks for any insights you can provide.

Steve Knowles -- Dave Peterson.

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 WorkbookOpen() are executed.

But I do not actually call the MARepairLinks sub from that event, anyway - its executed only when the user selects an action from the menu, after the workbook is open.

Thanks again for the tips; Ill let you know how it works out.

Complie Excel For Mac