I figured out a way. I built individual macros for each group of shapes to be invisible, then called on that macro in each case when I specified the individual shape to be visible, that way everything except the shape I want to be visible is invisible. I also broke down everything for each drop down into subs that begin with "select case range", and included all macro names into the main "worksheet change." I don't know if this is the best way, but it works beautifully. Thank you for your assistance Yraen.