I am trying to put together a standalone VBA macro that can easily be inserted into my financial models that allows me to quickly switch between two different printing setups – e.g. 8.5x 11 and 11x17 tabloid. I hope that was clear enough to understand. I have never used VBA or coding for that matter. I also am using excel 2007. Can anyone help me?