Global variables?

Originally Posted by leelnich

Hi all. @RustyNail, you might also consider moving your sub procedures to (the same?) standard module. Sheet and Workbook modules are traditionally reserved for event procedures and Class-related stuff.
http://www.cpearson.com/excel/codemods.htm

You mean move my setup sub in the same file as my other code...
if so, how do I get it to execute as soon as my workbook
Opens???