Solved

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

Posted on 2009-04-10
1
312 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
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

911 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now