This is in Excel 97. We have an Auto_open macro in a
worksheet, which is not running when the user opens the
file from the desktop.

We had to use Auto_Open rather than WorkbookOpen,
because this workbook will sometimes be opened by another
workbook (the caller uses RunAutoMacros), and
WorkbookOpen runs too quick. The workbook is loaded
from the corporate intranet site via a URL, and
WorkbookOpen runs a bit too early; causes timing issues.

Its working fine called from the other workbook, but on
some machines (mine and one of the testers; Windows
95), Auto_Open isn't running. As a workaround, I modified
Auto_Open and WorkbookOpen to call the same function,
and use a global variable to track whether the function has
run or not, but this concerns me. I could see timing issues
happening here if WorkbookOpen and Auto_Open
could overlap.

I can't find any references to Auto_Open being suppressed
-interactively-; WorkbookOpen runs fine, on the same
machines.

Any ideas?

--
Ron Ruble