I have found that with the use of "ThisWorkBook. ..." in the XLA that things
break andI believe that even the MS Manuals indicate it is not allowed
within an .XLA file. Try modifying that line of your code to not use the
"ThisWorkBook. ..." style of reference and see how that works.
Wayne Olson
Expert Allocation Services Inc.
Calgary, Alberta, Canada
"Mark" wrote in message
...
Tom,
Thanks alot! Both those pieces of code worked.
Mark
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!