How do I decare a Global variable that will be available to the entire workbook as a static. I need to procuce a lot of the same sheet with 2 name changes on each one, but the names are used throughout the code. It's easier to change 2 variables than go through the code and do it that way.