Solved

How to list or identify macros in office/visio documents?

Posted on 2009-04-10
1
317 Views
Last Modified: 2012-06-22
I hate Microsoft pop-up messages that warn you about problems but offer no information to help you decide what to do.  A classic example of this is the Security Warning message that pops up when you open a Microsoft Office document that essentially says "This file contains Macros.  Macros may contain Viruses.  It is usually safe to disable macros, but if the macros are litgitimate, you might loose functionallity."  Your options (buttons) are "Enable Macros" or "Disable Macros".  Well, great, there is a button missing here.  The one that says "Click here to see a list of active macros in this document" If I could see a list of the macros, I would then know whether to "Enable" or "Disable" them.   Thanks Microsoft; I don't recall putting any macros in my document, and I don't know if they are ligitimate or not, and I can't figure out how to list or see them.   They're not listed under any of the menu choices.   Anyone have a suggestion?   I hope the solution isn't something very simple, or I'm really going to feel stupid here; but this typical of Microsoft; error messages that don't include a button to google or search the knowledge base.
0
Comment
Question by:meyco
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 500 total points
ID: 24115071
meyco said:
>>Anyone have a suggestion?

Yes.  Choose "disable", then hit Alt+F11 to go to the VB Editor, and view the code yourself to get the list of
macros.  If you are satisfied that the macros are OK, close the file, reopen it, and enable this time.

I agree that it would be nice to see a list of macros in that enable/disable dialog, but this is a case where what
may look like a simple request is actually not so simple once you dive into the details :)
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question