Quote Originally Posted by BlueCactus
A little correction to the LoadPicture() issue:


Actually, it's slightly more complex. Although I could have sworn that this avoided the compiler errors before, it now doesn't work for me. I now recommend moving LoadPicture() to a different subroutine. That is:

For some reason, the top example will still cause compiler error under Excel X, even though the compiler should never process the conditional code.
Must be in a different module, not just in a different sub.

The compiler checks all the code to assure syntactic correctness.
Funny things can happen if code is inadvertently included in a compiler #IF.