How do I embed Visio drawings?

Hi all, I have a database set up and I want to have a cell with a drop down list of a list of places and when I click on a certain place I would like a Visio floor plan to come up in XL preferrably on another worksheet. I think I know how to embed to XL but how do I create the drop down list and link to the floor plans? I could hyperlink but I would rather keep within Excel. Also when I embed the visio drawing it messes up the printing if I want to print from XL. I am using version 2007

So there is no one out there that knows how to do this?