Sorry Rick, I've solved my problem -- sort of.

Seems that my code was somehow bombing. One of my modules was not compiling
correctly and therefore kept ALL of the modules from compiling. It had to do
with a removed reference that I did not want to be part of the file that I
distributed to others. However, by removing the reference the code was no
longer compiling, but oddly enough only doing it that way when Excel was not
already open. If Excel was open, all the modules compiled and ran fine,
except for the "bad" one, obviously.

This does not sound like your initial problem, but may help that other post
you linked here.

"Mike Jerakis" wrote:

I've got a file where the Sub Workbook_Open() code will not run if the file
is opened when Excel is not already open, i.e. opened from Explorer or
directly from an e-mail when Excel is not running. However, it runs
perfectly fine if Excel is already running, regardless of initiation method.
Any ideas?