Matt,

You don't need Option Compare Text to use conditional compilation
directives. The two are unrelated. You can put conditional
compilation directives in any code in any module.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Matthew Somers" wrote in message
...
Tom,

Thanks. I have a couple follow-ups.

1. Is it necessary to include "Option Compare Text" in modules
using
this directive.

2. Can the #if..Then..#Else conditional-compiler directive be
used in
any module or must it be placed in the Workbook_ Open() event.
I guess
I'm not really sure..what the compilation sequence is.

Thanks for both responses today. I might become your worst
nightmare.

Matt

p.s. Also, I love John Green's book "Excel 2000 VBA". Do you
have a book
out there?









*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!