The public variable needs to be a standard module. You can set it use Document_Open in the ThisDocument module or you could set it using AutoOpen in the same standard module. You don't need Static anywhere.

__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/