You can enable macros in Excel using the Trust Center or enable a specific macro from the security warning at the top of a ...

I have a document that has a Visio file embedded within a tab in Excel. This works fine. MIcrosoft even makes it easy to edit the Visio document. I just double click and it opens right up. It's great.